Removing a Column from a SQL Server Table

SQLOLEDB exposes ITableDefinition::DropColumn allowing consumers to remove a column from a SQL Server table.

Consumers specify the table name as a Unicode character string in the pwszName member of the uName union in the pTableID parameter. The eKind member of pTableID must be DBKIND_NAME.

The consumer indicates a column name in the pwszName member of the uName union in the pColumnID parameter. The column name is a Unicode character string. The eKind member of pColumnID must be DBKIND_NAME.

Note   Removing a column is not supported for a consumer connected to a server running Microsoft SQL Server version 4.21a, 6.0 or 6.5. ITableDefinition::DropColumn returns E_FAIL when the consumer application attempts to remove a column.