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

3 votes98 views2 answers
Search text in all sql server stored procedure
SQL
0 vote110 views1 answer
Sql find all different values in column
SQL
1 vote109 views3 answers
Drop unique key constraint in sql server
SQL
2 votes133 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote113 views1 answer
How to print sql query
SQL
0 vote114 views1 answer
Mssql last day of month
SQL
0 vote100 views1 answer
Sum sqlserver
SQL
1 vote113 views1 answer
Table valued functions in sql
SQL
0 vote114 views2 answers
Dumping sql table
SQL
0 vote114 views1 answer
Postgresql create query
SQL