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 vote326 views1 answer
Sql query to find duplicate email address
SQL
0 vote317 views1 answer
Install squirrel sql ubuntu
SQL
0 vote317 views2 answers
How to create a table from another table in sql derby
SQL
0 vote353 views1 answer
Sql server synonym
SQL
5 votes282 views1 answer
Mongodb vs
SQL
0 vote372 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote353 views1 answer
Change date format in oracle query
SQL
0 vote364 views1 answer
Sql show founctions
SQL
0 vote332 views1 answer
Primary key multiple colums
SQL
37 votes502 views3 answers
Sql check duplicate value in column
SQL