[top]
[prev]
[next]

Documentation Top
Global Index
Reference Manual
TOC Index
Grammar Index
Developer’s Guide
TOC Index
Tuning Cloudscape
TOC Index
|
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)
|