All databases
syssegments contains one row for each segment (named collection of disk pieces). In a newly created database, the entries are: segment 0 (system) for system tables; segment 2 (logsegment) for the transaction log; and segment 1 (default) for other objects.
The columns for syssegments are:
Name |
Datatype |
Description |
|---|---|---|
segment |
smallint |
Segment number |
name |
sysname |
Segment name |
status |
smallint null |
Indicates which segment is the default segment |
