removing-a-column-from-a-sql-server-table.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
Remove column from SQL Server table (Native Client OLE DB provider)	Removing a Column from a SQL Server Table (Native Client OLE DB provider)	markingmyname	maghan	03/14/2017	sql	native-client	reference	columns [OLE DB] removing columns DropColumn function SQL Server Native Client OLE DB provider, columns

Removing a Column from a SQL Server Table (Native Client OLE DB provider)

[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]

The [!INCLUDEssNoVersion] Native Client OLE DB provider exposes the ITableDefinition::DropColumn function. This allows consumers to remove a column from a [!INCLUDEssNoVersion] table.

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

The consumer indicates a column name in the pwszNamemember 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.

Example

Code

DBID TableID;  
DBID ColumnID;  
HRESULT hr;  
  
TableID.eKind = DBKIND_NAME;  
TableID.uName.pwszName = L"MyTableName";  
  
ColumnID.eKind = DBKIND_NAME;  
ColumnID.uName.pwszName = L"MyColumnName";  
  
hr = m_pITableDefinition->DropColumn(&TableID, &ColumnID);  

See Also

Tables and Indexes