MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for SQL Server


 

Schema Rowset Support in SQLOLEDB

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
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