Contains one row for each segment (named collection of disk fragments). When SQL Server is installed, this table contains three entries: segment 0 (system) for system tables, segment 1 (default) for other objects, and 2 (log segment) for the transaction log (the syslogs table). All entries in sysusages contain both of these segments and their maps.
Column | Datatype | Description |
---|---|---|
segment | smallint | Segment number |
name | varchar(30) | Segment name, used internally |
status | smallint | Default segment |
This table does not have any indexes.
sp_addsegment | sp_helpdb | sp_helpsegment |
sp_dropsegment | sp_helpindex | sp_placeobject |
sp_extendsegment |