> Is the functionlaity CASCADE is supported in drop
> table.
>
> i.e. drop table <table_name> cascade
>
> Note : CASCADE in drop table will remove associated
> child table constraints. (FK constraint)

You have to define the constraint with the desired CASCADE action. If you
then delete a master, the detail will be treated according to your
constraint definition.
Example:
ALTER TABLE MyTableDetail ADD CONSTRAINT FK_TableMasterID FOREIGN KEY
(DetailMasterID) REFERENCES MyTableMaster (ID) ON DELETE CASCADE;

would delete the detail record if the master record was deleted.

Florian