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)