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 vote276 views2 answers
Find a column in all tables mysql
SQL
6 votes357 views3 answers
What is where in sql
SQL
0 vote290 views1 answer
Teller stamp , bmo , PDF
SQL
1 vote286 views1 answer
Mysql return text after a final full stop
SQL
1 vote292 views2 answers
Mysql between
SQL
0 vote307 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote284 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote281 views1 answer
Convert rows into columns in oracle
SQL
2 votes302 views1 answer
Flask sqlalchemy boolean field
SQL
0 vote294 views1 answer
Selecting from a view SQL
SQL