S
Stevio
How do you delete or drop a foreign key relationship from an Access
database, using SQL, when the foreign key relationship was created within
Access so I do not know/have the name of the relationship?
I have found the SQL to do this but you need the name of the foreign key
relationship, which I don't have!
ALTER TABLE Table2 DROP CONSTRAINT Relation1
How can I find out the name, or how can I delete the relationship without
the name?
Thanks,
Stephen
database, using SQL, when the foreign key relationship was created within
Access so I do not know/have the name of the relationship?
I have found the SQL to do this but you need the name of the foreign key
relationship, which I don't have!
ALTER TABLE Table2 DROP CONSTRAINT Relation1
How can I find out the name, or how can I delete the relationship without
the name?
Thanks,
Stephen