I don't think it supports it in the current version. You can use
Declarative Referential Integrity constraints (DRI - references | foreign
key stuff) to enfore referential integrity. I think cascading is up to you
though. Probably a good idea to write some stored procs to do these
operations (e.g. sp_Delete( primary_key_value) and then delete all
dependent records before deleting the primary record). The other method
would be to use Triggers, it's my understanding that these can't be used if
you are using DRI. CAUTION: I am new to SQL Server programming so please,
verify my advice!
John B. Richards
Medical Care Systems, Inc.
Quote:> Does anyone know if SQL 6.5 actually performs cascade deletes and
> If so, how do you activates it?