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
TABLE-NAME	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
LOCK GRANULARITY	CHAR	1	false	Indicates the lock granularity for the table 'T' (table level locking) 'R' (row level locking, the default)

---

Previous Page
Next Page
Table of Contents
Index