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.

See Also

Columns and Tables Append Methods, Name Property Example (VB) | Keys Append Method, Key Type, RelatedColumn, RelatedTable and UpdateRule Properties Example (VB) | ParentCatalog Property Example (VB)

Append Method (Groups) | Append Method (Indexes) | Append Method (Keys) | Append Method (Procedures) | Append Method (Tables) | Append Method (Users) | Append Method (Views)

Applies To: Columns Collection