Hey, if you want, I'll send you a file that a predecessor created called,
interestingly enough, "cascading_delete.cfm" (it's a ColdFusion file - dunno
if you're a CF guy)... it's used as a custom tag that will call itself as
many times as necessary, digging through the schema tables in a SQL7 db to
get down as far as it needs, then delete its way back up the tree...
-----Original Message-----
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 11:35 AM
To: SQL
Subject: Cascading Deletes
I have a series of tables joined with foriegn keys and
want to do cascading deletes with them so that if a
row from the top table is deleted all the records with
that key will be deleted as well. In SQL 2000 you can
set an option to have this done automatically, but it
doesn't look like SQL 7 has this feature. How do I go
about doing it in SQL 7, wouldn't happen to be an
update that adds this feature is there?
=====
Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
ICQ UIN: 916324
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
