Append Method (ADOX Columns)

Microsoft ActiveX Data Objects (ADO)

Append Method (Columns)

       

Adds a new Column object to the Columns collection.

Syntax

Columns.Append Column [, Type] [, DefinedSize]

Parameters

Column   The Column object to append or the name of the column to create and append.

Type   Optional. A Long value that specifies the data type of the column. The Type parameter corresponds to the Type property of a Column object.

DefinedSize   Optional. A Long value that specifies the size of the column. The DefinedSize parameter corresponds to the DefinedSize property of a Column object.

Note   An error will occur when appending a Column to the Columns collection of an Index if the Column does not exist in a Table that is already appended to the Tables collection.