"ON DELETE CASCADE" references more than one table

Hi All,

I have a table

CREATE TABLE address (..., ownerId int, ...)

I alse have many other tables, such as employee, contractor, vender.... All of these table can own an address.

What is the best way to delete an address if I delete an employee or contractor?

I can not use

FOREIGN KEY (customerId) REFERENCES customer (id)

on address, because I can only reference customer, not employee or contractor.

Any information would be appreciated. Thanks in advance. Received on Sun Mar 02 2003 - 08:59:52 CST