append-method-adox-keys.md

title	Append Method (ADOX Keys) | 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	Keys::Append Keys::raw_Append
helpviewer_keywords	Append method [ADOX]
ms.assetid	215a5391-f422-42ec-99ea-4e6fbb5d3d64
author	MightyPen
ms.author	genemi

Append Method (ADOX Keys)

Adds a new Key object to the Keys collection.

Syntax

  
Keys.Append Key [,KeyType] [,Column] [,RelatedTable] [,RelatedColumn]  

Parameters

Key
The Key object to append or the name of the key to create and append.

KeyType
Optional. A Long value that specifies the type of key. The Key parameter corresponds to the Type property of a Key object.

Column
Optional. A String value that specifies the name of the column to be indexed. The Columns parameter corresponds to the value of the Name property of a Column object.

RelatedTable
Optional. A String value that specifies the name of the related table. The RelatedTable parameter corresponds to the value of the Name property of a Table object.

RelatedColumn
Optional. A String value that specifies the name of the related column for a foreign key. The RelatedColumn parameter corresponds to the value of the Name property of a Column object.

Remarks

The Columns parameter can take either the name of a column or an array of column names.

Applies To

Keys Collection (ADOX)

See Also

Keys Append Method, Key Type, RelatedColumn, RelatedTable and UpdateRule Properties Example (VB)
Append Method (ADOX Columns)
Append Method (ADOX Groups)
Append Method (ADOX Indexes)
Append Method (ADOX Procedures)
Append Method (ADOX Tables)
Append Method (ADOX Users)
Append Method (ADOX Views)