hi,

i have created a table of category like

///////////create table category(cat_id int,Name varchar(20),primary
key(cat_id)) engine=InnoDB;///////////////

again i ahave cretaed a child table (sub_cat) having foreign key on
the category table's cat_id. like

////////create table sub_cat(cat_id int,Name varchar(20),Type
varchar(20),Author varchar(20),
INDEX c_id (cat_id), foreign key(cat_id)
references category(cat_id) on delete cascade)
ENGINE=INNODB; ////////////

But the problem is that when you are deleting the parent tables cat_id
its consequnce child tables cat_id is not deleting.
I have created a index also on the child
table so as to delete the respective data.
But unable to use it.
If any one have the answer pls forward.....

Caution:Its working in Oracle9i
Regards
Priyaranjan