keys-collection-adox.md

title	Keys Collection (ADOX) | Microsoft Docs
ms.prod	sql
ms.prod_service	connectivity
ms.technology	connectivity
ms.custom
ms.date	01/19/2017
ms.reviewer
ms.topic	conceptual
apitype	COM
f1_keywords	Table::Keys Keys
helpviewer_keywords	Keys collection [ADOX]
ms.assetid	cdb31c76-e559-475c-b33a-aac24f73e70e
author	MightyPen
ms.author	genemi

Keys Collection (ADOX)

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.

This section contains the following topic.

• Indexes Collection Properties, Methods, and Events

See Also

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