Schema Rowset Support (OLE DB)
The SQL Native Client OLE DB provider also supports returning schema information from a linked server when processing Transact-SQL distributed queries.
The following tables list schema rowsets and the restriction columns supported by the SQL Native Client OLE DB provider.
| Schema rowset | Restriction columns |
|---|---|
DBSCHEMA_CATALOGS |
CATALOG_NAME |
DBSCHEMA_COLUMN_PRIVILEGES |
All the restrictions are supported. TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME GRANTOR GRANTEE |
DBSCHEMA_COLUMNS |
All the restrictions are supported. TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME |
DBSCHEMA_FOREIGN_KEYS |
All restrictions are supported. PK_TABLE_CATALOG PK_TABLE_SCHEMA PK_TABLE_NAME FK_TABLE_CATALOG FK_TABLE_SCHEMA FK_TABLE_NAME |
DBSCHEMA_INDEXES |
Restrictions 1, 2, 3, and 5 are supported. TABLE_CATALOG TABLE_SCHEMA INDEX_NAME TABLE_NAME |
DBSCHEMA_PRIMARYKEYS |
All restrictions are supported. TABLE_CATALOG TABLE_SCHEMA TABLE_NAME |
DBSCHEMA_PROCEDURE_PARAMETERS |
All restrictions are supported. PROCEDURE_CATALOG PROCEDURE_SCHEMA PROCEDURE_NAME PARAMETER_NAME |
DBSCHEMA_PROCEDURES |
Restrictions 1, 2, and 3 are supported. PROCEDURE_CATALOG PROCEDURE_SCHEMA PROCEDURE_NAME |
DBSCHEMA_PROVIDER_TYPES |
All restrictions are supported. DATA_TYPE BEST_MATCH |
DBSCHEMA_SCHEMATA |
All restrictions are supported. CATALOG_NAME SCHEMA_NAME SCHEMA_OWNER |
DBSCHEMA_STATISTICS |
All restrictions are supported. TABLE_CATALOG TABLE_SCHEMA TABLE_NAME |
DBSCHEMA_TABLE_CONSTRAINTS |
All restrictions are supported. CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE |
DBSCHEMA_TABLE_PRIVILEGES |
All restrictions are supported. TABLE_CATALOG TABLE_SCHEMA TABLE_NAME GRANTOR GRANTEE |
DBSCHEMA_TABLES |
All restrictions are supported. TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE |
DBSCHEMA_TABLES_INFO |
All restrictions are supported. TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE |