TechNet
Export (0) Print
Expand All

Tables and Indexes

 

System_CAPS_ICON_warning.jpg Warning

SQL Server Native Client (SNAC) is not supported beyond SQL Server 2012. Avoid using SNAC in new development work, and plan to modify applications that currently use it. The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows to Microsoft SQL Server and Microsoft Azure SQL Database.

The SQL Server Native Client OLE DB provider exposes the IIndexDefinition and ITableDefinition interfaces, allowing consumers to create, alter, and drop SQL Server tables and indexes. Valid table and index definitions depend on the version of SQL Server.

The ability to create or drop tables and indexes depends on the SQL Server 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 SQL Server use SQL-DMO instead of these SQL Server Native Client OLE DB provider interfaces. SQL-DMO is a collection of OLE Automation objects that support all the administrative functions of SQL Server. 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, SQL Server defines the following property.

Property IDDescription
SSPROP_COL_COLLATIONNAMEType: 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)

Community Additions

ADD
Show:
© 2016 Microsoft