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 vote344 views1 answer
Cast as decimal postgresql
SQL
0 vote360 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote357 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote375 views1 answer
Sql select upcoming birthdays
SQL
0 vote373 views1 answer
Mysql listing get a particu particular user firsdt
SQL
4 votes385 views1 answer
Find tables with column name in sql
SQL
3 votes357 views2 answers
Mysql user permission database
SQL
0 vote358 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
5 votes346 views1 answer
Ignore duplicate rows in sqlite
SQL
5 votes389 views2 answers
Functions
SQL