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 vote139 views1 answer
Stored function in sql
SQL
-1 vote140 views1 answer
How to dump .csv file into mysql
SQL
0 vote158 views1 answer
Sql date time query find
SQL
0 vote141 views1 answer
SQL: calculate hours from two dates
SQL
8 votes134 views2 answers
Between operator
SQL
1 vote146 views1 answer
Oracle enable job
SQL
0 vote130 views1 answer
Mysql cdn link
SQL
5 votes140 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote143 views1 answer
Mysql local password denied
SQL
1 vote145 views1 answer
How to select multiple columns from different tables in mysql
SQL