Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Schema Rowset Support in SQLOLEDB

Schema Rowset Support in SQLOLEDB

SQL Server 2000

If you connect to an earlier version of Microsoft® SQL Server™ 2000, 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


Show:
© 2015 Microsoft