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

6 votes340 views1 answer
Sqlite foreign key
SQL
4 votes362 views2 answers
Mysql alter table set column unique
SQL
4 votes347 views2 answers
Mysql show indexes on table
SQL
14 votes368 views2 answers
Oracle export trigger ddl
SQL
0 vote321 views1 answer
Create bakupd database sqlserver
SQL
0 vote369 views1 answer
Alasql delete column
SQL
0 vote374 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote357 views1 answer
Horizontal join sqlite
SQL
-3 votes383 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
2 votes348 views1 answer
Copy all values of a column to another column in sql in same table
SQL