On Mon, Apr 04, 2005 at 02:56:56AM -0400, brew@theMode.com wrote:
>
> Is there a SQL command that removes both a row in a table and the rows in
> other tables that reference it or do I have to do it manually?
If you define the foreign key constraints as ON DELETE CASCADE,
then referencing rows will be automatically deleted when you DELETE
the referenced row.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
