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 vote226 views1 answer
Oracle query archivemode
SQL
0 vote215 views1 answer
Redirection 301 htaccess nom de domaine
SQL
2 votes217 views2 answers
Install sqlalchemy
SQL
0 vote186 views1 answer
Oracle sysdba connect as another user
SQL
9 votes229 views4 answers
Last mysql
SQL
4 votes227 views3 answers
Oracle sql first day of quarter
SQL
0 vote230 views1 answer
Sql server concat null
SQL
0 vote255 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
3 votes231 views4 answers
Show databases in sql server
SQL
0 vote213 views1 answer
Oracle drop default value
SQL