| title | Tables and indexes (Native Client OLE DB provider) | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| description | Tables and Indexes in SQL Server Native Client | ||||||||
| author | markingmyname | ||||||||
| ms.author | maghan | ||||||||
| ms.date | 03/14/2017 | ||||||||
| ms.service | sql | ||||||||
| ms.subservice | native-client | ||||||||
| ms.topic | reference | ||||||||
| helpviewer_keywords |
|
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]
The [!INCLUDEssNoVersion] Native Client OLE DB provider exposes the IIndexDefinition and ITableDefinition interfaces, allowing consumers to create, alter, and drop [!INCLUDEssNoVersion] tables and indexes. Valid table and index definitions depend on the version of [!INCLUDEssNoVersion].
The ability to create or drop tables and indexes depends on the [!INCLUDEssNoVersion] access rights of the consumer-application user. Dropping a table can be further constrained by the presence of declarative referential integrity constraints or other factors.
Most applications targeting [!INCLUDEssNoVersion] use SQL-DMO instead of these [!INCLUDEssNoVersion] Native Client OLE DB provider interfaces. SQL-DMO is a collection of OLE Automation objects that support all the administrative functions of [!INCLUDEssNoVersion]. Applications targeting multiple OLE DB providers use these generic OLE DB interfaces that are supported by the various OLE DB providers.
In the provider-specific property set DBPROPSET_SQLSERVERCOLUMN, [!INCLUDEssNoVersion] defines the following property.
| Property ID | Description |
|---|---|
| SSPROP_COL_COLLATIONNAME | Type: VT_BSTR R/W: Write Default: Null Description: This property is used only in ITableDefinition. The string specified in this property is used when creating a CREATE TABLE statement. |
SQL Server Native Client (OLE DB)
DROP TABLE (Transact-SQL)
CREATE INDEX (Transact-SQL)
DROP INDEX (Transact-SQL)