Administration BDD Course Materials & Test Answers | moodle.learn.ynov.com

Quelle commande permet de créer une clé étrangère avec une action en cascade sur une table existante ?

`ALTER TABLE table_name ADD FOREIGN KEY (column_name) REFERENCES other_table (column_name) CASCADE ON DELETE;`

`ALTER TABLE table_name ADD FOREIGN KEY (column_name) REFERENCES other_table (column_name) WITH CASCADE;`

`ALTER TABLE table_name ADD FOREIGN KEY (column_name) REFERENCES other_table (column_name) ON DELETE CASCADE;`

100%

`ALTER TABLE table_name ADD FOREIGN KEY (column_name) REFERENCES other_table (column_name) DELETE CASCADE;`

View this question

Crowdly