solidDB Help : solidDB reference : SQL: Database system tables and system views : System tables : SYS_TABLES
  
SYS_TABLES
This table lists all the system tables.
There are no restrictions for viewing the system tables, which means even users with no access rights can view them. However, specific users are restricted from viewing the user table information. Owners are restricted to viewing user tables they have created and users can only view tables to which they have INSERT, UPDATE, DELETE, or SELECT access. Users are restricted from viewing any user tables if they have no access rights. No restrictions apply to DBAs.
The columns in the SYS_TABLES system table are described in the following table:
 
Column name
Data type
Description
ID
INTEGER
Unique table identifier.
TABLE_NAME
WVARCHAR
The name of the table.
TABLE_TYPE
WVARCHAR
The type of the table (BASE TABLE or VIEW).
TABLE_SCHEMA
WVARCHAR
The name of the schema containing TABLE_NAME
TABLE_CATALOG
WVARCHAR
The name of the catalog containing TABLE_NAME.
CREATIME
TIMESTAMP
The creation time of the table.
CHECKSTRING
LONG WVARCHAR
Possible check option defined for the table.
REMARKS
LONG WVARCHAR
Reserved for future use.
Go up to
System tables