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 vote306 views1 answer
Sql group by sum with condition
SQL
0 vote314 views1 answer
What is SQL data store?
SQL
1 vote300 views1 answer
Blob datatype in mysql
SQL
1 vote277 views10 answers
Stack overflow
SQL
1 vote285 views1 answer
Can not connect to mysql server
SQL
1 vote295 views4 answers
Mysqldump 1 table only
SQL
0 vote285 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote305 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
1 vote310 views1 answer
How to lock table in mysql
SQL
1 vote310 views1 answer
Oracle sql first day of year
SQL