| title | Add column to SQL Server table (Native Client OLE DB provider) | ||||
|---|---|---|---|---|---|
| description | Add column to SQL Server table (Native Client OLE DB provider) | ||||
| author | markingmyname | ||||
| ms.author | maghan | ||||
| ms.date | 03/14/2017 | ||||
| ms.service | sql | ||||
| ms.subservice | native-client | ||||
| ms.topic | reference | ||||
| helpviewer_keywords |
|
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]
The [!INCLUDEssNoVersion] Native Client OLE DB provider exposes the ITableDefinition::AddColumn function. This allows consumers to add a column to a [!INCLUDEssNoVersion] table.
When you add a column to a [!INCLUDEssNoVersion] table, the [!INCLUDEssNoVersion] Native Client OLE DB provider 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 [!INCLUDEssNoVersion] 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.