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 vote249 views1 answer
Change data type in mysql
SQL
3 votes270 views1 answer
Oracle list dates without weekends
SQL
0 vote260 views1 answer
Case insensitive sql
SQL
0 vote265 views1 answer
Transaction database with php
SQL
0 vote347 views1 answer
Oracle db timestamp auto add
SQL
2 votes273 views1 answer
Db.relationship sqlalchemy flask
SQL
2 votes249 views1 answer
Update trigger
SQL
1 vote262 views2 answers
Install mysqldump ubuntu
SQL
2 votes264 views1 answer
Oracle apex list connected users
SQL
2 votes269 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL