Edit

Append Method (ADOX Keys)

  • Article

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)