通过

InsertColumn Method

后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能，并着手修改当前还在使用该功能的应用程序。

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

语法

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);

备注

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

ms136870.note(zh-cn,SQL.90).gif注意：
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