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

10 votes193 views1 answer
Create table oracle
SQL
2 votes264 views2 answers
Sql query to copy data from one column to another
SQL
0 vote218 views1 answer
Oracle table privileges
SQL
0 vote245 views1 answer
Drush run sql select
SQL
-1 vote211 views2 answers
Installing mysql on centos 7
SQL
1 vote226 views1 answer
Oracle show execution plan
SQL
7 votes205 views2 answers
Execute mysql file
SQL
0 vote231 views1 answer
Sql server pivot rows to columns
SQL
3 votes202 views1 answer
APEX elapsed time
SQL
2 votes242 views1 answer
Pandas to sql index
SQL