Keys Collection (ADOX)

Microsoft ActiveX Data Objects (ADO)

Keys Collection

           

Contains all Key objects of a table.



Remarks

The Append method for a Keys collection is unique for ADOX. You can:

  • Add a new key to the collection with the Append method.

The remaining properties and methods are standard to ADO collections. You can:

  • Access a key in the collection with the Item property.

  • Return the number of keys contained in the collection with the Count property.

  • Remove a key from the collection with the Delete method.

  • Update the objects in the collection to reflect the current database's schema with the Refresh method.