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 votes280 views3 answers
Rename table column postgresql
SQL
3 votes272 views4 answers
Order by desc postgres
SQL
0 vote269 views1 answer
Unique element in sql
SQL
31 votes259 views3 answers
Sql count
SQL
0 vote276 views1 answer
Java sql connection
SQL
1 vote305 views1 answer
Insert many to many sql
SQL
0 vote271 views1 answer
Sql alter table order by
SQL
4 votes281 views2 answers
Show all database inside postgresql
SQL
-2 votes290 views2 answers
Union all in sql
SQL
5 votes280 views1 answer
Sort order on two columns sql
SQL