SQL Guide : Database system tables and system views : System views : TABLES
  
TABLES
The TABLES system view identifies the tables accessible to the current user.
Column name
Data type
Description
TABLE_CATALOG
WVARCHAR
The name of the catalog containing TABLE_NAME.
TABLE_SCHEMA
WVARCHAR
The name of the schema containing TABLE_NAME.
TABLE_NAME
WVARCHAR
The name of the table or view.
TABLE_TYPE
WVARCHAR
The type of the table.
REMARKS
LONG WVARCHAR
Reserved for future use.
See also
System views