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

21 votes143 views5 answers
Oracle all tables
SQL
2 votes154 views1 answer
Sql string_agg
SQL
1 vote142 views1 answer
Update and replace mysql
SQL
0 vote198 views1 answer
Sql server is not
SQL
3 votes171 views2 answers
Find string in stored procedure sql server
SQL
1 vote149 views2 answers
Reset mysqli fetch_arra
SQL
0 vote273 views2 answers
Mysql insert rows to another database
SQL
0 vote143 views1 answer
Get all employees if name ends with in sql
SQL
1 vote139 views1 answer
Sql eliminare un record
SQL
0 vote154 views1 answer
Google cloud sql postgres url example
SQL