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

8 votes321 views5 answers
Alter table add column with default value
SQL
0 vote353 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
0 vote297 views1 answer
Import sql mysql ubuntu
SQL
0 vote289 views1 answer
Create bakupd database sqlserver
SQL
3 votes335 views2 answers
Oracle apex charging debug
SQL
4 votes337 views1 answer
Search column by name mysql
SQL
0 vote346 views1 answer
How to update date value in sql
SQL
1 vote381 views1 answer
Mariadb get column names from table
SQL
0 vote345 views1 answer
Sql mod even odd
SQL
0 vote341 views1 answer
Mariadb cast null to 0
SQL