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 vote178 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
0 vote202 views1 answer
Get last inserted primary key
SQL
2 votes189 views1 answer
Oracle trace session
SQL
1 vote189 views1 answer
Mysql is odd
SQL
0 vote140 views1 answer
Display first three characters sql
SQL
12 votes142 views4 answers
Mysql version query
SQL
3 votes172 views1 answer
Mysql cli connect with password
SQL
1 vote163 views2 answers
Intersect sql
SQL
0 vote158 views1 answer
Postgresql show owner of database
SQL
0 vote145 views2 answers
Mysql dump database tables only
SQL