SYSTABLES

Describes the tables and views within the current database.
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), or 'V' (view)
SCHEMAID CHAR 36 false schema id for the table or view
LOCK GRANULARITY CHAR 1 false Indicates the lock granularity for the table
'T'
(table level locking)
'R'
(row level locking, the default)
Related reference
SYSALIASES
SYSCHECKS
SYSCOLPERMS
SYSCOLUMNS
SYSCONGLOMERATES
SYSCONSTRAINTS
SYSDEPENDS
SYSFILES
SYSFOREIGNKEYS
SYSKEYS
SYSROUTINEPERMS
SYSSCHEMAS
SYSSTATISTICS
SYSSTATEMENTS
SYSTABLEPERMS
SYSTRIGGERS
SYSVIEWS