> 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

Without knowing the name, you cannot drop the constraint.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com