| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Add column to SQL Server table (OLE DB driver) |
Learn how the ITableDefinition::AddColumn method allows consumers to add a column to a SQL Server table in OLE DB Driver for SQL Server. |
David-Engel |
davidengel |
06/14/2018 |
sql |
connectivity |
reference |
|
[!INCLUDE SQL Server]
[!INCLUDEDriver_OLEDB_Download]
The OLE DB Driver for SQL Server 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 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 [!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.