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

0 vote253 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote305 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
1 vote304 views1 answer
Rows to comma separated values in mssql
SQL
3 votes272 views1 answer
What is having clause
SQL
2 votes318 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote323 views1 answer
Mysql collation portugues brasil
SQL
8 votes306 views1 answer
How to check mysql version in xampp
SQL
0 vote289 views1 answer
Psql check if value in array
SQL
2 votes317 views2 answers
Get all tables using like
SQL
-1 vote317 views2 answers
Installing mysql on centos 7
SQL