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

1 vote268 views1 answer
Date_part mysql
SQL
0 vote276 views1 answer
Mysql config address
SQL
5 votes244 views1 answer
Mysql change primary key
SQL
0 vote257 views1 answer
What alter does in db
SQL
8 votes269 views1 answer
Sql limit results returned
SQL
0 vote247 views1 answer
Get foreign table names mysql
SQL
0 vote261 views1 answer
Sqlite version check
SQL
0 vote252 views1 answer
Sql find table by name
SQL
0 vote265 views4 answers
How to connect form to database
SQL
0 vote262 views1 answer
Sintaxis SELECT sql
SQL