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 vote99 views1 answer
Raven ql select count
SQL
0 vote137 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote125 views1 answer
Mysql earlier than date
SQL
1 vote159 views1 answer
Sql server set variable if exists
SQL
0 vote149 views1 answer
Creating h2 database in relative directory eclopse
SQL
4 votes132 views1 answer
Update table from another table oracle
SQL
15 votes217 views3 answers
Postgresql change column type
SQL
0 vote135 views1 answer
Set a value by excuting stored procedure
SQL
0 vote138 views1 answer
Dump db only triggers mysql
SQL
0 vote130 views1 answer
Best sql collation
SQL