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 vote133 views1 answer
How to update date value in sql
SQL
0 vote124 views1 answer
Oracle create job if not exists
SQL
14 votes146 views4 answers
Online sql compiler
SQL
2 votes121 views1 answer
Oracle cpu per session
SQL
0 vote125 views1 answer
Rabbitmq service not starting
SQL
0 vote126 views1 answer
Check index sql server
SQL
1 vote118 views1 answer
How to get mysql db size
SQL
0 vote137 views1 answer
Sql select min row
SQL
11 votes123 views1 answer
Oracle view ddl
SQL
0 vote120 views1 answer
Sql string length postgresql
SQL