J
jma
I'm trying to edit table foreign key(s). I would like to use sql drop
constraint and make a new one with alter table but I don't know the name
of the foreign key.
1. Can I somehow display all (foreign keys) on database/table?
2. What is default name for foreign keys in Access?
I have tried these:
ALTER TABLE table1
DROP CONSTRAINT xxx
xxx=table2, table2_id, FK_table2, table2_FK, FK_table2_id, table2_id_FK, ...
constraint and make a new one with alter table but I don't know the name
of the foreign key.
1. Can I somehow display all (foreign keys) on database/table?
2. What is default name for foreign keys in Access?
I have tried these:
ALTER TABLE table1
DROP CONSTRAINT xxx
xxx=table2, table2_id, FK_table2, table2_FK, FK_table2_id, table2_id_FK, ...