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

4 votes123 views2 answers
How to delete row in sql
SQL
0 vote129 views1 answer
List in one column mysql
SQL
1 vote134 views1 answer
Mysql how to truncate table with foreign keys
SQL
10 votes125 views3 answers
Insert into auto increment mysql
SQL
8 votes114 views2 answers
Phpmyadmin password
SQL
0 vote131 views1 answer
Postgresql in vs any performance
SQL
-1 vote132 views2 answers
First letter capital in mysql query
SQL
0 vote129 views1 answer
Mysql sql.gz
SQL
1 vote133 views1 answer
Mysql return if it contains
SQL
0 vote135 views1 answer
ACCEPT nome PROMPT on oracle
SQL