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 vote198 views1 answer
Copy value from one column to another postgres
SQL
0 vote366 views1 answer
The differnece between to values in sql
SQL
0 vote393 views1 answer
Multiple row join
SQL
0 vote194 views1 answer
Oracle list proxy users
SQL
1 vote151 views1 answer
Postgres division by zero
SQL
0 vote246 views1 answer
Use mysql in java program
SQL
1 vote210 views1 answer
Vagrant mysql downgrade version
SQL
0 vote203 views1 answer
Find all tables where column name exists oracle
SQL
0 vote208 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote210 views2 answers
Plsql function that return a table
SQL