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

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.