# 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.

Table 1. 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)

Parent topic: Derby system tables