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

1 vote94 views2 answers
Procedure pl/sql
SQL
0 vote132 views1 answer
How to import sqlite driver class in java using maven
SQL
34 votes166 views6 answers
Alter table add foreign key mysql
SQL
1 vote177 views1 answer
Concat first name and last name in mysql
SQL
0 vote146 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
1 vote134 views3 answers
Psql fatal database does not exist
SQL
0 vote88 views1 answer
How to check oracle index table
SQL
0 vote141 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
1 vote124 views1 answer
How to test for sql injection
SQL
0 vote157 views1 answer
Mysql could not fetch tables
SQL