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 vote202 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote221 views1 answer
Tsql pad left
SQL
10 votes187 views2 answers
Sql where clause multiple values
SQL
0 vote226 views1 answer
Add multiple field in table sql
SQL
0 vote223 views1 answer
View to table
SQL
0 vote227 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote217 views1 answer
Mysql failed to login as root@localhost
SQL
1 vote201 views1 answer
Oracle start job
SQL
2 votes225 views1 answer
Mysql select default if null
SQL
0 vote227 views1 answer
Sql dmv to capture updates
SQL