Foreign Keys and Cascading Deletes

Foreign Keys and Cascading Deletes

Post by Andrey Kruchko » Mon, 16 Dec 1996 04:00:00

I look the text of system procedure that talk information about foreign
keys and find that this properties is write in it as const. In 6.5 you can
not make fk cascad delete .It may be in next version?


Andrey Kruchkov, RTW95, RWNTUG
Windows 95 Trainer, Quarta Ltd.

> I was wondering if anyone has information regrading Foreign Keys and
> Cascading of Updates and Deletes.  I have used other SQL Engines which
> allow this.  I also noticed in the Transact-SQL Documentation a
> reference to this under "sp_fkeys" talking about UPDATE_RULE and DELETE
> _RULE.