| title | Schema Rowset Support (OLE DB) | Microsoft Docs | |||||
|---|---|---|---|---|---|---|
| ms.custom | ||||||
| ms.date | 03/06/2017 | |||||
| ms.prod | sql-server-2014 | |||||
| ms.reviewer | ||||||
| ms.technology | native-client | |||||
| ms.topic | reference | |||||
| helpviewer_keywords |
|
|||||
| ms.assetid | a75b4b69-b095-4690-9b31-a2b32a67489e | |||||
| author | MightyPen | |||||
| ms.author | genemi | |||||
| manager | craigg |
The [!INCLUDEssNoVersion] Native Client OLE DB provider also supports returning schema information from a linked server when processing [!INCLUDEtsql] distributed queries.
Note
Although [!INCLUDEssNoVersion] supports synonyms, metadata for synonyms is not returned by [!INCLUDEssNoVersion] Native Client.
The following tables list schema rowsets and the restriction columns supported by the [!INCLUDEssNoVersion] 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 The following additional columns are specific to [!INCLUDEssNoVersion]: - COLUMN_LCID, which is the locale ID of the collation. COLUMN_LCID is the same value as a Windows LCID. - COLUMN_COMPFLAGS defines which comparisons are supported for the collation. The data format is the same as DBPROB_FINDCOMPAREOPS. - COLUMN_SORTID, which is the [!INCLUDEssNoVersion] sorting style for the collation. - COLUMN_TDSCOLLATION, which is the [!INCLUDEssNoVersion] collation for the column. - IS_COMPUTED, which is VARIANT_TRUE if the column is a computed column and VARIANT_FALSE otherwise. |
| 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_PRIMARY_KEYS | 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_PROCEDURES returns only procedures that can be executed by the current user, or for which the current user has been granted VIEW DEFINITION permission. |
| 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 |