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 vote225 views1 answer
Select the date 30 days less that the todays date sql request
SQL
0 vote287 views1 answer
Example database query
SQL
6 votes212 views2 answers
Join vs union
SQL
0 vote190 views1 answer
Subquery aggregation
SQL
1 vote200 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
0 vote209 views1 answer
Learnxinyminutes sql
SQL
0 vote211 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote194 views1 answer
Sql server select value large text
SQL
1 vote184 views1 answer
Group_concat max length mysql
SQL
0 vote231 views1 answer
Select 1 from orders
SQL