Cascade syntax in sql

<COLUMN> <DATATYPE> <CONSTRAINT NAME> REFERENCES <MASTER TABLE
NAME> (<PRIMARY KEY COLUMN>)
ON DELETE {NO ACTION/CASCADE/SET NULL/ DEFAULT}
ON UPDATE {NO ACTION / CASCADE /SET NULL/ DEFAULT}

Cascade syntax in sql

DELETE Rules:
1. ON DELETE NO ACTION
2. ON DELETE CASCADE
3. ON DELETE SET NULL
4. ON DELETE SET DEFAULT

UPDATE Rules:
1. ON UPDATE NO ACTION
2. ON UPDATE CASCADE
3. ON UPDATE SET NULL
4. ON UPDATE SET DEFAULT

Similar codes

2 votes177 views1 answer
Sql find missing values between two tables
SQL
0 vote188 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
2 votes176 views2 answers
Mysql user access to database
SQL
0 vote188 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote221 views1 answer
Alter fedora mysql 8.0 user
SQL
2 votes180 views1 answer
Mysql clear screen
SQL
0 vote182 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
2 votes178 views1 answer
Oracle generated column
SQL
0 vote188 views1 answer
Select odd records sql
SQL
0 vote182 views2 answers
MySQL top percent
SQL