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 vote160 views1 answer
Closure in sql
SQL
0 vote146 views1 answer
Postgresql get current user name
SQL
0 vote166 views1 answer
Mysql check datetime equals date
SQL
0 vote150 views1 answer
Add created and updatedAt fields in mysql
SQL
1 vote149 views2 answers
How to check username in mysql command line
SQL
0 vote156 views1 answer
Postgres in operator with comma separated values
SQL
0 vote142 views1 answer
How to find unique key in sql
SQL
4 votes151 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
20 votes196 views4 answers
How to find average in sql
SQL
0 vote110 views1 answer
Mysqli or pdo
SQL