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