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

14 votes343 views4 answers
Online sql compiler
SQL
4 votes351 views3 answers
Rename table column postgresql
SQL
1 vote349 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
1 vote311 views1 answer
Select not matching data from two tables
SQL
0 vote330 views1 answer
Postgres copy command
SQL
0 vote357 views1 answer
Mssql unique key accept nulls
SQL
0 vote335 views1 answer
Drop unique
SQL
0 vote388 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote335 views2 answers
MySQL top percent
SQL
0 vote348 views1 answer
How to delete python anywhere mysql database
SQL