Subject Re: [firebird-support] Drop meta data statements
Author Helen Borrie
At 03:01 PM 19/01/2005 +1300, you wrote:

>Is it possible to create the following statements with IB EXPERT (or any
>other admin tools)
>drop referential integrety constraints.

DROP CONSTRAINT <constraint-name>

But it won't work if the constraint has other constraints depending on it,
e.g. a PH has foreign keys pointing to it.

>drop procedures

DROP PROCEDURE <procedure-name>

>drop generators

DROP GENERATOR <generator-name> (Firebird only)

>drop triggers

DROP TRIGGER <trigger-name>

Have you thought about bookmarking a standard SQL reference?