| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Tables and indexes (OLE DB driver) |
Learn about the OLE DB Driver interfaces IIndexDefinition and ITableDefinition, which allow consumers to create, alter, and drop SQL Server tables and indexes. |
David-Engel |
davidengel |
06/14/2018 |
sql |
connectivity |
reference |
|
[!INCLUDE SQL Server]
[!INCLUDEDriver_OLEDB_Download]
The OLE DB Driver for SQL Server 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 OLE DB Driver for SQL Server 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. |
OLE DB Driver for SQL Server Programming
DROP TABLE (Transact-SQL)
CREATE INDEX (Transact-SQL)
DROP INDEX (Transact-SQL)