--- In firebird-support@yahoogroups.com, "Schlup, Herbert"
<Herbert.Schlup@o...> wrote:

> 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.

The sql sample here
(http://www.fbtalk.net/post.php?action=post&fid=13) will retreive the
name of the foreign key given a table/column combo.

hih

rgds

Si Carter
http://www.tectsoft.net/