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

27 votes251 views6 answers
Sql update record
SQL
0 vote307 views1 answer
SQL query to verify the size of the table
SQL
1 vote193 views3 answers
Execute sp in sql server
SQL
0 vote197 views1 answer
Open postgresql.conf in centos
SQL
0 vote240 views1 answer
Stored function in sql
SQL
0 vote200 views1 answer
Multiple left join mysql
SQL
0 vote191 views1 answer
Sql how to display two atributes as one in sql
SQL
1 vote204 views1 answer
SQL Integer devision
SQL
0 vote187 views1 answer
Get yesterday date ISO in psql
SQL
0 vote187 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL