Key Object (ADOX)

Represents a primary, foreign, or unique key field from a database table.

Remarks

The following code creates a new Key:

Dim obj As New Key  

With the properties and collections of a Key object, you can:

• Identify the key with the Name property.

• Determine whether the key is primary, foreign, or unique with the Type property.

• Access the database columns of the key with the Columns collection.

• Specify the name of the related table with the RelatedTable property.

• Determine the action performed on deletion or update of a primary key with the DeleteRule and UpdateRule properties.

This section contains the following topic.

• Key Object Properties, Methods, and Events

See Also

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