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

4 votes265 views1 answer
Sql quote in string
SQL
1 vote284 views1 answer
Mysql show attributes of a table
SQL
2 votes265 views4 answers
List databases in sql server
SQL
0 vote329 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote275 views1 answer
Oracle for loop on list
SQL
1 vote273 views1 answer
Drop function
SQL
0 vote258 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
0 vote265 views1 answer
Mysql cast null to string
SQL
0 vote264 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote242 views1 answer
Sql random decimal
SQL