Thought I had it knocked, but just ran into a subsequent snag. When I try to delete the key, I'm getting error -2147467259: "Cannot delete this index or table - it is either the current index or is used in a relationship."
Here's the code:
Set mobjTable = mCat.Tables("Customer")
For Each objIndex In mobjTable.Indexes
If objIndex.Name = "ZipCodeCustomer" Then
objIndex doesn't have a delete method, so the above delete was the only way I could figure out to do it. Does anyone know how to delete a relationship programmatically?