append-method-adox-columns.md

title	Append Method (ADOX Columns) | Microsoft Docs
ms.prod	sql
ms.prod_service	connectivity
ms.technology	connectivity
ms.custom
ms.date	01/19/2017
ms.reviewer
ms.topic	conceptual
apitype	COM
f1_keywords	Columns::raw_Append Columns::Append
helpviewer_keywords	Append method [ADOX]
ms.assetid	7a46d23c-efef-4ec7-815d-cd3ac86787dd
author	MightyPen
ms.author	genemi

Append Method (ADOX 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.

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)