Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to enable cascade delete

0 views
Skip to first unread message

Souc Jan

unread,
Feb 18, 1999, 3:00:00 AM2/18/99
to
How to enable cascading delete of rows in referenced tables?

Thanks in advance


regards

Jan

Neil Pike

unread,
Feb 18, 1999, 3:00:00 AM2/18/99
to
Jan,

> How to enable cascading delete of rows in referenced tables?
>

Q. Where are the cascade update/delete functions in SQL Server?
(v1.0 25.09.1998)

A. There aren't any I'm afraid. These were initially thought to be going into
SQL 7 but won't be there now. They will be in a "future" SQL release.

You need to implement your own cascade functionality with triggers. See
Q142480 in the MS Kb for more information on this and the ways to work with
foreign keys which cause problems due to the way that triggers work/fire.

Neil Pike MVP/MCSE. Protech Computing Ltd
(Please post ALL replies to the newsgroup only unless indicated otherwise)
For SQL FAQ entries see www.ntfaq.com/sql.html
and http://www.swynk.com/faq/sql/sqlserverfaq.asp
and GO MSSQL lib 1 on Compuserve

0 new messages