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

20 votes200 views4 answers
Sqlite create table if not exists
SQL
0 vote194 views1 answer
Mysql trim characters
SQL
0 vote211 views1 answer
Flush user resource mysql
SQL
1 vote227 views3 answers
How to pass password to mysql command line
SQL
0 vote201 views1 answer
SQL loop with cursor
SQL
0 vote260 views1 answer
Osm2pgsql mac
SQL
0 vote197 views1 answer
Mysql shell set time_zone
SQL
1 vote224 views1 answer
Floor function in sql oracle
SQL
0 vote228 views1 answer
Disable database droping sql
SQL
0 vote212 views1 answer
Complete date is 1 year or not sql server
SQL