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 vote117 views1 answer
Oracle simple quote
SQL
2 votes127 views1 answer
How to insert string variable into sqlite database
SQL
0 vote130 views1 answer
Drop all triggers oracle
SQL
1 vote135 views3 answers
Update from select sqlite
SQL
0 vote175 views1 answer
Run docker container with database as rds metabase
SQL
13 votes118 views2 answers
Sql count distinct group by
SQL
0 vote123 views1 answer
What is the use of index in mysql table
SQL
0 vote122 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote112 views1 answer
Get who is hired in month in sql
SQL
12 votes136 views10 answers
Google
SQL