On delete set default

ON DELETE SET DEFAULT

SQL Server sets the rows in the child table to their default values
if the corresponding rows in the parent table are deleted.

To execute this action, the foreign key columns must have default definitions.

"Note that: a nullable column has a default value of (NULL) 
 if no default value specified "

Source: sqlservertutorial.net

Similar codes

0 vote292 views2 answers
Delete the last item in a table sql
SQL
0 vote364 views1 answer
Tinydb add table
SQL
4 votes335 views2 answers
Bulk kill mysql processlist
SQL
0 vote564 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote329 views1 answer
Sql server count all tables rows
SQL
3 votes391 views1 answer
Oracle sql commit example
SQL
23 votes334 views4 answers
How to uninstall postgresql in ubuntu
SQL
2 votes367 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote382 views1 answer
Mariadb create index if not exists
SQL
0 vote332 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL