raghoos_2000 wrote:

>
> Hi,
> Could anyone tell me the syntax for dropping a table which is
> being referenced.Like in oracle we can have
> drop table <tablename> cascade constraints;

That would be useful in some circumstances. Does not exist in IB/FB.

I use scripts to do such things and place them in a Delphi program with
buttons to each new such operation required. This includes disabling/enabling
triggers and dropping/adding constraints. I do nothing directly with the
database except test the scripts.
--
Raymond Kennington
Programming Solutions
TeamW2W (InfoPower)