Add ON DELETE CASCADE to the references in book.
On Mon, 12 Mar 2001, Marcelo Pereira wrote:
> 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 ???