The following table shows the contents of the SYSTABLES system table.
SYSTABLES system table
For each column in the SYSTABLES system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents.
Column Name
Type
Length
Nullable
Contents
TABLEID
CHAR
36
false
Unique identifier for table or view
TABLENAME
VARCHAR
128
false
Table or view name
TABLETYPE
CHAR
1
false
'S' (system table), 'T' (user table),
'A' (synonym), or 'V' (view)
SCHEMAID
CHAR
36
false
Schema ID for the table or view
LOCKGRANULARITY
CHAR
1
false
Lock granularity for the table: 'T' (table level
locking) or 'R' (row level locking, the default)