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 vote164 views1 answer
Trigger in postgresql to change incoming entry
SQL
1 vote167 views1 answer
Mysql query where in select
SQL
0 vote174 views1 answer
How to find all children of a record with only parent ID in sql
SQL
1 vote193 views4 answers
How to check table in postgresql from terminal
SQL
1 vote157 views1 answer
Error code 1055
SQL
0 vote178 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote161 views1 answer
Install mysql for fedora 34
SQL
0 vote190 views1 answer
T-SQL Create Trigger
SQL
0 vote157 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
3 votes186 views3 answers
Docker create postgresql database
SQL