Subject | How to drop a contstraint where I don't know the name |
---|---|
Author | Schlup, Herbert |
Post date | 2005-05-18T19:46:22Z |
Hi all
I need to drop a constraint from a table. I know the tablename and that
the constraint is a foreign key to another table. But as the constraint
has no specific name, it can be called INTEG_xx....
How can I now drop this constraint without knowing the name? I need to
do this by script on several databases.
Thank you
Herbert
ALTER TABLE CUSTOMERINFO DROP CONSTRAINT INTEG_87
I need to drop a constraint from a table. I know the tablename and that
the constraint is a foreign key to another table. But as the constraint
has no specific name, it can be called INTEG_xx....
How can I now drop this constraint without knowing the name? I need to
do this by script on several databases.
Thank you
Herbert
ALTER TABLE CUSTOMERINFO DROP CONSTRAINT INTEG_87