apache > db
Apache DB Project
 
Font size:      

SYSTABLES

SYSTABLES

Describes the tables and views within the current database.

Column NameTypeLengthNullableContents
TABLEIDCHAR36falseunique identifier for table or view
TABLE-NAMEVARCHAR128falsetable or view name
TABLETYPECHAR1false'S' (system table), 'T' (user table), or 'V' (view)
SCHEMAIDCHAR36falseschema id for the table or view
LOCK GRANULARITYCHAR1falseIndicates the lock granularity for the table
'T'
(table level locking)
'R'
(row level locking, the default)

Previous Page
Next Page
Table of Contents
Index