SYSTABLES System Table

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

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

SYSTABLES system table
Column Name Type Length Nullable Contents
TABLEID CHAR 36 NO Unique identifier for table or view
TABLENAME VARCHAR 128 NO Table or view name
TABLETYPE CHAR 1 NO

Possible values are:

  • 'S' (system table)
  • 'T' (user table)
  • 'A' (synonym)
  • 'V' (view)
SCHEMAID CHAR 36 NO Schema ID for the table or view
LOCKGRANULARITY CHAR 1 NO

Lock granularity for the table:

  • 'T' (table level locking)
  • 'R' (row level locking, the default)
VERSION VARCHAR 128 YES Version ID.

See Also