Pro Members, SQL Server, Standard Members

Tips for using constraints in SQL Server 2017

Tips for using constraints in SQL Server 2017 Use cascading referential integrity constraints instead of triggers whenever possible. For example, if you need to make cascading deletes or updates, specify the ON DELETE or ON UPDATE clause in the REFERENCES clause of the CREATE TABLE or ALTER TABLE statement. The cascading referential integrity constraints are much more efficient than triggers…

This content is for Pro, Pro Member, Pro Member Annual – Valentine’s, Pro Member Monthly – Valentine’s, Standard, Standard Member, Standard Member Annual – Valentine’s and Standard Member Monthly – Valentine’s members only.
Log In Register

Comments are closed.