[GENERAL] Delete Cascade

[Marcelo Pereira]

Hi,   I am in trouble deleting rows in cascade.   I have a scheme like this:   create table author (author_cod integer primary key, author_name char(20)); create table book (book_cod integer primary key, book_autor integer references author(author_cod), book_title char(30));   I would like to delete a 'author' in the author table and also all your books in the book table.   When I run   delete from author where author_cod = <number>   I dont get the row deleted if there is a row referenced by in the book table. How can I delete my rows in cascade ???   Thanks in advance,   Marcelo Pereira Computer Programmer