If you connect to an earlier version of Microsoft® SQL Server™, you must upgrade the catalog stored procedures on that server before the SQLOLEDB provider can give proper results in schema rowsets. SQLOLEDB 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 SQLOLEDB.
| Schema rowset | Restriction columns |
|---|---|
| DBSCHEMA_CATALOGS | CATALOG_NAME |
| DBSCHEMA_COLUMN_PRIVILEGES | All the restrictions are supported.
TABLE_CATALOG |
| DBSCHEMA_COLUMNS | All the restrictions are supported.
TABLE_CATALOG |
| DBSCHEMA_FOREIGN_KEYS | All restrictions are supported.
PK_TABLE_CATALOG |
| DBSCHEMA_INDEXES | Restrictions 1, 2, 3, and 5 are supported.
TABLE_CATALOG |
| DBSCHEMA_PRIMARYKEYS | All restrictions are supported.
TABLE_CATALOG |
| DBSCHEMA_PROCEDURE_PARAMETERS | All restrictions are supported.
PROCEDURE_CATALOG |
| DBSCHEMA_PROCEDURES | Restrictions 1, 2, and 3 are supported.
PROCEDURE_CATALOG |
| DBSCHEMA_PROVIDER_TYPES | All restrictions are supported.
DATA_TYPE |
| DBSCHEMA_SCHEMATA | All restrictions are supported.
CATALOG_NAME |
| DBSCHEMA_STATISTICS | All restrictions are supported.
TABLE_CATALOG |
| DBSCHEMA_TABLE_CONSTRAINTS | All restrictions are supported.
CONSTRAINT_CATALOG |
| DBSCHEMA_TABLE_PRIVILEGES | All restrictions are supported.
TABLE_CATALOG |
| DBSCHEMA_TABLES | All restrictions are supported.
TABLE_CATALOG |
| DBSCHEMA_TABLES_INFO | All restrictions are supported.
TABLE_CATALOG |