Events
Get certified in Microsoft Fabric—for free!
19 Nov, 11 pm - 10 Dec, 11 pm
For a limited time, the Microsoft Fabric Community team is offering free DP-600 exam vouchers.
Prepare nowThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
The OLE DB Driver for SQL Server also supports returning schema information from a linked server when processing Transact-SQL distributed queries.
Note
Although SQL Server supports synonyms, metadata for synonyms is not returned by OLE DB Driver for SQL Server.
The following tables list schema rowsets and the restriction columns supported by the OLE DB Driver for SQL Server.
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 SQL Server: 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 SQL Server sorting style for the collation. COLUMN_TDSCOLLATION, which is the SQL Server 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 |
Distributed Query Support in Schema Rowsets
OLE DB Driver for SQL Server Programming
Using User-Defined Types
Events
Get certified in Microsoft Fabric—for free!
19 Nov, 11 pm - 10 Dec, 11 pm
For a limited time, the Microsoft Fabric Community team is offering free DP-600 exam vouchers.
Prepare now