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