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

12 votes136 views4 answers
Psql command not found
SQL
0 vote140 views1 answer
WHERE not regex in SQL
SQL
0 vote132 views1 answer
Mariadb select limit offset
SQL
3 votes129 views1 answer
Only join in sql
SQL
58 votes302 views4 answers
Mysql drop column
SQL
1 vote124 views1 answer
Create temporal table in sql
SQL
0 vote121 views1 answer
Django how to get query result count
SQL
0 vote128 views1 answer
Python sql last insertend
SQL
1 vote130 views1 answer
Not exists mysql
SQL
0 vote124 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL