The SYSTABLES table describes the tables and views within the current database.
The following table shows the contents of the SYSTABLES system table.
| 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), 'A' (synonym), or 'V' (view) |
| SCHEMAID | CHAR | 36 | false | Schema ID for the table or view |
| LOCKGRANULARITY | CHAR | 1 | false | Lock granularity for the table: 'T' (table level locking) or 'R' (row level locking, the default) |