Tables Schema Rowset - OLE DB Provider for Teradata

Tables Schema Rowset

Table 36: Tables Schema Rowset

Default Sort Order	Supported Restrictions	Supported Columns
TABLE_TYPE TABLE_SCHEMA TABLE_NAME	TABLE_SCHEMA TABLE_NAME TABLE_TYPE	TABLE_SCHEMA TABLE_NAME TABLE_TYPE DESCRIPTION DATE_CREATED DATE_MODIFIED

Specify Restrictions

The following restrictions apply:

If the provider string attribute “Use X View” is set to YES (the default), and TABLE_NAME is unrestricted, then only tables that the user has access to are returned.

In addition, if a table name has been specified, then a search is conducted only against those tables that the user has privilege to access.

Or, if the provider string attribute “Use X View” is set to NO, and TABLE_NAME is unrestricted, then all tables contained in the database are returned.

Table Types

The valid values for TABLE_TYPE are:

SYSTEM TABLE

TABLE

SYSTEM VIEW

VIEW

V (where “V” is VIEW or SYSTEM VIEW)

T (where “T” is TABLE or SYSTEM TABLE)