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 vote277 views1 answer
Database timezone
SQL
1 vote286 views1 answer
Mysql query where in select
SQL
12 votes318 views6 answers
Distinct in sql server
SQL
3 votes342 views2 answers
Oracle drop sequence
SQL
0 vote294 views1 answer
SAP Return
SQL
0 vote280 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote259 views1 answer
Sqlite3 not commit
SQL
0 vote275 views1 answer
Create new table pl sql
SQL
2 votes270 views1 answer
Install sqlite npm
SQL
4 votes275 views2 answers
What is table in sql
SQL