SYSTABLES system table The SYSTABLES table describes the tables and views within the current database. system tablesSYSTABLES tablesSYSTABLES system table viewsSYSTABLES system table SYSTABLES system table

The following table shows the contents of the SYSTABLES system table.

SYSTABLES system tableFor 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)