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

0 vote144 views1 answer
Hibernate dialect property xml for mysql 8
SQL
6 votes135 views1 answer
Wordpress change user password sql
SQL
8 votes190 views3 answers
Postgres database sizes
SQL
0 vote140 views1 answer
Mysql search like but first exact match
SQL
1 vote146 views1 answer
Db.Database.SqlQuery
SQL
0 vote648 views1 answer
Sql show table name in result
SQL
0 vote153 views2 answers
How to find max and min salary in sql
SQL
1 vote170 views1 answer
Limit offset order by mysql
SQL
0 vote144 views1 answer
Mysql xampp reset root password
SQL
0 vote166 views2 answers
Drop tables from local table database postgres
SQL