Share via

TABLES Rowset

  • Article

GUID: DBSCHEMA_TABLES

Number of restriction columns: 4

Restriction columns: TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE

Default sort order: TABLE_TYPE, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME

Description: The TABLES rowset identifies the tables (including views) defined in the catalog that are accessible to a given user.

Column name

Type indicator

Description

TABLE_CATALOG

DBTYPE_WSTR

Catalog name. NULL if the provider does not support catalogs.

TABLE_SCHEMA

DBTYPE_WSTR

Unqualified schema name. NULL if the provider does not support schemas.

TABLE_NAME

DBTYPE_WSTR

Table name. This column cannot contain NULL.

TABLE_TYPE

DBTYPE_WSTR

Table type. One of the following or a provider-specific value:

  • "ALIAS"

  • "TABLE"

  • "SYNONYM"

  • "SYSTEM TABLE"

  • "VIEW"

  • "GLOBAL TEMPORARY"

  • "LOCAL TEMPORARY"

  • "SYSTEM VIEW"

This column cannot contain NULL.

TABLE_GUID

DBTYPE_GUID

GUID that uniquely identifies the table. Providers that do not use GUIDs to identify tables should return NULL in this column.

DESCRIPTION

DBTYPE_WSTR

Human-readable description of the table. Null if there is no description associated with the column.

TABLE_PROPID

DBTYPE_UI4

Property ID of the table. Providers that do not use PROPIDs to identify columns should return NULL in this column.

DATE_CREATED

DBTYPE_DATE

Date when the table was created or NULL if the provider does not have this information. Note that 1.x providers do not return this column.

DATE_MODIFIED

DBTYPE_DATE

Date when the table definition was last modified or NULL if the provider does not have this information.

1.x providers do not return this column.