Hi Aaron.
>I have a "One to Many" relationship:
>Table: ITEM
>Index: itemcage
>Related Table: INV
>Related Index: itmcageuic
>
>I want to change the relationship to use index BY_ITEM in ITEM (which already exists), but ALTER TABLE seems to want me to ADD/ALTER/DROP a column just to use the REFERENCES argument. Am I missing something? Any help would be appreciated.
Here's the syntax for ALTER TABLE:
alter table CHILDTABLE add foreign key EXPRESSION tag TAGNAME references PARENTTABLE tag PARENTTAG
You don't have to drop the current indexes (although you may not need them anymore so you may want to do that anyway).
Doug