Alter constraint in sql

You can not alter constraints ever but you can drop them and then recreate.

Have look on this

    ALTER TABLE your_table DROP CONSTRAINT ACTIVEPROG_FKEY1;

and then recreate it with ON DELETE CASCADE like this

    ALTER TABLE your_table
    add CONSTRAINT ACTIVEPROG_FKEY1 FOREIGN KEY(ActiveProgCode) REFERENCES PROGRAM(ActiveProgCode)
        ON DELETE CASCADE;
hope this help

Similar codes

25 votes105 views6 answers
Import mysql database command line
SQL
6 votes104 views4 answers
Sqlite drop table
SQL
0 vote123 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote99 views1 answer
Kotlin sqlite delete row
SQL
1 vote125 views1 answer
Connect to mysql database ubuntu
SQL
0 vote101 views1 answer
Mysql case when on date
SQL
0 vote108 views2 answers
Zsh: command not found: mysq
SQL
0 vote108 views1 answer
T sql less than date
SQL
3 votes104 views2 answers
Mysql time
SQL
4 votes107 views2 answers
Select first and last row mysql
SQL