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 vote316 views1 answer
Changing name of column and datatype in sql
SQL
0 vote322 views1 answer
Postrgres trunc
SQL
8 votes314 views1 answer
Script to add datafile to tablespace
SQL
0 vote295 views1 answer
Mssql current date
SQL
10 votes324 views2 answers
Mysql alter add foreign key
SQL
0 vote312 views1 answer
Create table as select sql server error
SQL
0 vote304 views1 answer
Postgres data location
SQL
0 vote330 views1 answer
Primary key multiple
SQL
0 vote293 views1 answer
Systemverilog unique constraint unique values
SQL
2 votes311 views1 answer
Postgresql create schema in specific database
SQL