Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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

Community Additions

ADD
Show:
© 2015 Microsoft