Export (0) Print
Expand All

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:
© 2014 Microsoft