Friday, January 12, 2018

ON DELETE CASCADE

Put this in a foreign key in T-SQL. It will allow for deleting a key that other records are dependent upon. The dependent records just get the axe too. Anarchy! This kinda goes in the place of more mundane ends to foreign keys like:

ON UPDATE NO ACTION ON DELETE NO ACTION

No comments:

Post a Comment