Key Object

 

Description

 

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

 

Remarks

 

The following code creates a new Key:

 

DIM pKey AS ADOXKey

pKey = NEWCOM "ADOX.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.

 

Valid XHTML 1.0 Transitional