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 vote180 views1 answer
Mysql 5.7 in centos 7
SQL
5 votes221 views1 answer
Get table columns from sql
SQL
0 vote217 views1 answer
MySQL get all previous date record
SQL
0 vote178 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
1 vote189 views2 answers
Test sqlsrv connection
SQL
2 votes244 views1 answer
Mariadb json select
SQL
0 vote182 views1 answer
Sql server datetime to string
SQL
3 votes183 views1 answer
Sql server version query
SQL
0 vote214 views1 answer
Sql server synonym
SQL
13 votes185 views1 answer
Fetch first 5 rows in oracle sql developer
SQL