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. |
|