Export (0) Print
Expand All

Tables and Indexes

SQL Server 2000

SQLOLEDB exposes the IIndexDefinition and ITableDefinition interfaces, allowing consumers to create, alter, and drop Microsoft® SQL Server™ 2000 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 2000 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 2000 use SQL-DMO instead of these OLE DB interfaces. SQL-DMO is a collection of OLE Automation objects that support all the administrative functions of SQL Server 2000. 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 ID Description
SSPROP_COL_COLLATIONNAME Type: VT_BSTR
R/W:W
Default: Null
Description: This property is used only in ITableDefinition. The string specified in this property is used when creating a CREATE TABLE statement.

See Also

CREATE TABLE

DROP TABLE

CREATE INDEX

DROP INDEX

Show:
© 2014 Microsoft