No cascading foreign keys, have to create triggers
SQL Server stops you from creating cascading foreign keys and forces you to create triggers. If I can create triggers that do the right thing then the SQL Server team should be able to implement it automatically for me for foreign keys. Doing triggers is time consuming, error prone and shouldn't be necessary.
Upvotes: 2<=-=Apr 11 2006 9:00PM=-=>
Hi – Thanks for your feedback. We’ll certainly consider this for future release of SQL Server.
- Christian Kleinerman<=-=Aug 20 2008 4:14PM=-=>
I have resolved this item as duplicate of another suggestion. You can view it at:
Umachandar, SQL Programmability Team