Drop Relations

  • Thread starter Thread starter Klaus L Jensen
  • Start date Start date
K

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
 
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"
 
Back
Top