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

1 vote208 views2 answers
Sql where keyword
SQL
0 vote209 views1 answer
Sql auto_increment syntax
SQL
0 vote217 views1 answer
How to add more columns to a table in mysql
SQL
0 vote174 views1 answer
Java spring boot connect to sql server
SQL
2 votes170 views1 answer
Sql float to int
SQL
1 vote284 views2 answers
Copy table in sql
SQL
5 votes218 views1 answer
Oracle get foreign keys on table
SQL
16 votes268 views1 answer
Mysql mediumint max value
SQL
0 vote236 views1 answer
Updating database in sql
SQL
0 vote210 views1 answer
Codeigniter dbforge add index
SQL