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

Question

Answer

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

Answer

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

Answer

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

Answer

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

Crowdly