syssegments

All databases

Description

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.

Columns

The columns for syssegments are:

Name

Datatype

Description

segment

smallint

Segment number

name

sysname

Segment name

status

smallint

Indicates which segment is the default segment