Adding a Column to a SQL Server Table

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database YesAzure SQL Managed Instance yesAzure Synapse Analytics yesParallel Data Warehouse

DownloadDownload OLE DB Driver

The OLE DB Driver for SQL Server exposes the ITableDefinition::AddColumn function. This allows consumers to add a column to a SQL Server table.

When you add a column to a SQL Server table, the OLE DB Driver for SQL Server consumer is constrained as follows:

  • If DBPROP_COL_AUTOINCREMENT is VARIANT_TRUE, DBPROP_COL_NULLABLE must be VARIANT_FALSE.

  • If the column is defined by using the SQL Server timestamp data type, DBPROP_COL_NULLABLE must be VARIANT_FALSE.

  • For any other column definition, DBPROP_COL_NULLABLE must be VARIANT_TRUE.

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 new column name is specified as a Unicode character string in the pwszName member of the uName union in the dbcid member of the DBCOLUMNDESC parameter pColumnDesc. The eKind member must be DBKIND_NAME.

See Also

Tables and Indexes
ALTER TABLE (Transact-SQL)