Drop Relations

[Klaus L Jensen]

I need to know how to drop / create relation..

ALTER TABLE <table> DROP CONSTRAIN <relation>

does not work



Please help


Med venlig hilsen
Klaus Ladegaard Jensen

 

[Roger Carlson]

It should. Here's one that works for me:
ALTER TABLE BookSQL DROP CONSTRAINT PubBook;

I *think* the table has to be on the Many-side of the relationship.

You can also use DAO:
Dim db As DAO.Database
Set db = CurrentDb
db.Relations.Delete "PubBook"

 

[Tim Ferguson]

ALTER TABLE <table> DROP CONSTRAIN <relation>

does not work

The word is CONSTRAINT


HTH


Tim F