The adSchemaTables QueryType identifies the tables defined in the catalog that are accessible to a given user. The rowset returned by an adSchemaTables QueryType contains the following columns:
| 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. |
| 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" |
| 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. |
The default sort order for the adSchemaTables rowset is TABLE_TYPE, TABLE_CATALOG, TABLE_SCHEMA, and TABLE_NAME.