Append Method (ADOX Keys)

Microsoft ActiveX Data Objects (ADO)

ADOX 2.5 API Reference

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

See Also

Keys Append Method, Key Type, RelatedColumn, RelatedTable and UpdateRule Properties Example (VB)

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

Applies To: Keys Collection

© 1998-2003 Microsoft Corporation. All rights reserved.