Cloudscape System Tables
Page 15 of 17

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

LOCKGRANULARITY

CHAR

1

false

Indicates the lock granularity for the table

'T' (table level locking)

'R' (row level locking, the default)

Indexes

  • SYSTABLES_INDEX1 unique BTREE index on (TABLENAME, SCHEMAID)
  • SYSTABLES_INDEX2 unique BTREE index on (TABLEID)