Subject How to drop a contstraint where I don't know the name
Author Schlup, Herbert
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