SYSTABLES system table

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), 'A' (synonym), 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)
Parent topic: Derby system tables