Tables and Indexes

SQLOLEDB exposes the IIndexDefintion 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. For more information, see CREATE TABLE and CREATE INDEX.

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. For more information, see DROP TABLE and DROP INDEX.