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 vote133 views1 answer
Mysql find missing values
SQL
0 vote152 views1 answer
Sql getdate minus 1 day without time
SQL
15 votes152 views4 answers
Pl sql
SQL
0 vote147 views1 answer
Sql common columns
SQL
1 vote134 views1 answer
Postgres killing connections on db
SQL
0 vote147 views2 answers
How to display enum value sql server
SQL
0 vote150 views1 answer
Sql values not in another table
SQL
0 vote195 views1 answer
Oracle create package specification
SQL
0 vote133 views2 answers
Sql last updated
SQL
7 votes173 views3 answers
Sql server check if temp table exists
SQL