append-method-adox-keys.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	apitype
Append Method (ADOX Keys)	Append Method (ADOX Keys)	rothja	jroth	01/19/2017	sql	ado	reference	Keys::Append Keys::raw_Append	Append method [ADOX]	COM

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)