InsertColumn Method

SQLServer.Database.Table Object

Description

Inserts a new column into an existing table or a new but not added Table. To insert a new column as the last column of an existing table, first call the BeginAlter method, then call InsertColumn, then call the DoAlter method. To insert a new column into the specified position of a new Table, call InsertColumn before adding the new Table to the Database.Tables collection.

Visual Basic

Table.InsertColumn (
[NewColumn :=] Column,
[BeforeColumnName :=] idBeforeColumn )

C++

HRESULT pTable->InsertColumn (
LPSQLOLECOLUMN
pColumn,
SQLOLE_LPCSTR
idBeforeColumn );

Elements

Element Type Description

Column Column Column object to be inserted.
idBeforeColumn Identifier If not empty, the Column object will inserted before this column name. If empty, the Column object will be the last column of the table. To insert a new column into an existing table, this value must be empty.