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 votes238 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote232 views3 answers
Convert sql query to python pandas
SQL
0 vote287 views1 answer
Mysql get nested records
SQL
0 vote241 views1 answer
SQL Cut part string
SQL
1 vote201 views2 answers
Get table column names sql laravel
SQL
0 vote200 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote233 views1 answer
Count number of entires by months sql
SQL
0 vote209 views1 answer
Postgresql function ROUND
SQL
1 vote268 views1 answer
Postgresql float 2 decimal places
SQL
1 vote196 views1 answer
Oracle apex prevent initial load
SQL