DICTIONARY.TABLES

The following table lists the columns that appear in the result table for the DICTIONARY.TABLES table.

Note: Null indicates either a null or a missing value.

Column name	Column number	Data type	Description
TABLE_CAT	1	NVARCHAR not Null	Catalog name
TABLE_SCHEM	2	NVARCHAR	Schema name; null if not applicable to the data source. If a driver supports schemas for some tables but not for others, such as when the driver retrieves data from different DBMSs, it returns an empty string ("") for those tables that do not have schemas.
TABLE_NAME	3	NVARCHAR not null	Table name
TABLE_TYPE	4	NVARCHAR not null	Table type name; one of the following: TABLE, VIEW, SYSTEM TABLE, GLOBAL TEMPORARY, LOCAL TEMPORARY, ALIAS, SYNONYM, or a data source-specific type name. The meanings of ALIAS and SYNONYM are driver-specific.
REMARKS	5	NVARCHAR	A description of the table
NATIVE_CAT	6	NVARCHAR	The native data store's Catalog; null if not applicable to the data source. If a driver supports catalogs for some tables but not for others, such as when the driver retrieves data from different DBMSs, it returns an empty string ("") for those tables that do not have catalogs.