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 vote394 views1 answer
Python get backup of sql
SQL
4 votes273 views1 answer
Oracle sleep
SQL
0 vote355 views1 answer
SQL: calculate hours from two dates
SQL
11 votes353 views2 answers
How to import mysql database command line
SQL
-1 vote338 views3 answers
How to restart mysql in linux
SQL
14 votes320 views1 answer
Excel is not a database
SQL
7 votes377 views1 answer
Buy forge mods server hosting
SQL
0 vote309 views1 answer
Go install mysql
SQL
5 votes306 views2 answers
Ranking functions in sql
SQL
1 vote330 views1 answer
Change old domain to new domain name wordpress
SQL