Append Method (ADOX Columns)

Adds a new Column object to the Columns collection.


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


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

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

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


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.

Applies To

Columns Collection (ADOX)

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 (ADOX Groups)
Append Method (ADOX Indexes)
Append Method (ADOX Keys)
Append Method (ADOX Procedures)
Append Method (ADOX Tables)
Append Method (ADOX Users)
Append Method (ADOX Views)