At 03:01 PM 19/01/2005 +1300, you wrote:

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

ALTER TABLE
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?

./hb