How can I implement something like ON DELETE CASCADE with Torque?

Like: let's say table BOOK references table AUTHOR through a relation WROTE.
Now let's say I have BOOK_ID 1 and AUTHOR_ID 1 and AUTHOR_ID 2 (because the
book was written by 2 authors).
Then I have the following WROTE:

BOOK_ID   AUTHOR_ID
1         1
1         2

But now let's assume I wish to delete the book.

With SQL I simply create the table WROTE with ON DELETE CASCADE so once I
delete the book, the database also deletes all references (e.g. in WROTE)

How can I do that with Torque?

Thanks

Matt


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to