Share via

InsertColumn Method

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The InsertColumn method adds a column to the Columns collection of a Table object at the position indicated.

Syntax

object.InsertColumn(Column,InsertBeforeColumn)

Parts

  • object
    Expression that evaluates to an object in the Applies To list.

  • Column
    Expression that evaluates to a Column object.

  • InsertBeforeColumn
    String that names an existing Column object in the Columns collection of a Table object.

Prototype (C/C++)

HRESULT InsertColumn(
LPSQLDMOCOLUMN pNewColumn,
SQLDMO_LPCSTR szBeforeColumn);

Remarks

Use the InsertColumn method when the ordinal position of a column must be maintained.

Note

Columns in existing Microsoft SQL Server tables have fixed ordinal ___location. You cannot use the InsertColumn method when the Table object references an existing SQL Server table. Use InsertColumn only when the Table object is used to create a SQL Server table.

Applies To:

Table Object