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

7 votes315 views2 answers
Get database size mysql
SQL
5 votes349 views4 answers
Restart the psql server windows
SQL
0 vote345 views1 answer
Sql if clause within where clause
SQL
1 vote327 views1 answer
Import sql file mysql commadn line
SQL
1 vote357 views1 answer
Sql order by timestamp
SQL
0 vote327 views1 answer
List all functions and procedures in postgres query
SQL
5 votes362 views4 answers
Upload database mysql command line
SQL
1 vote365 views1 answer
Get current date in pyspark sql
SQL
0 vote324 views1 answer
Number(10 2) in sql means
SQL
0 vote342 views1 answer
Compare two tables to find unmatched records
SQL