ON DELETE CASCADE in Transact-SQL

Most of the database programming I've done is in MS SQL 2000. When working in SQL 7, though, the ON DELETE CASCADE feature of creating a table doesn't exist. I suspect you could make a trigger to handle this or you could try out a stored procedure to do the trick. I haven't tried it myself and I'd think a trigger would be more intuitive but it's there if I need it.

Published October 28, 2003 · Updated September 17, 2005
Categorized as SQL
Short URL: http://snook.ca/s/38

Conversation

1 Comment · RSS feed
1
ebony said on June 27, 2005

Gracis amigo

Sorry, comments are closed for this post. If you have any further questions or comments, feel free to send them to me directly.