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 vote171 views1 answer
Is not null postgresql
SQL
19 votes179 views3 answers
How to change column type psql
SQL
0 vote198 views1 answer
"Hello User Name"
SQL
10 votes256 views4 answers
Sql server pagination
SQL
0 vote182 views1 answer
How to put is null in where in clause
SQL
2 votes190 views1 answer
Mysql cannot delete or update a parent row
SQL
41 votes259 views6 answers
Alter table add column in SQL Server
SQL
0 vote177 views4 answers
Sql rownum
SQL
0 vote171 views1 answer
Mysql max number not returning correct value
SQL
0 vote182 views1 answer
Remove transient options sql wordpress
SQL