TABLES

Information on all the tables for which the current authorization identifier has privileges or is the owner.

Column name	Data type	Contents
TABLE_CATALOG	CHAR (18)	Database name
TABLE_SCHEMA	CHAR (31)	Name of the schema to which the table belongs
TABLE_NAME	CHAR (31)	Name of the base table or view
TABLE_TYPE	VARCHAR (18)	BASE TABLE or VIEW

Table 97: TABLES view of the INFORMATION_SCHEMA