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 vote123 views1 answer
Mysql filter based on datediff
SQL
0 vote121 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote103 views1 answer
Frename oracle
SQL
0 vote117 views1 answer
Check psql validity function
SQL
0 vote114 views1 answer
Sql server cannot create database diagram
SQL
1 vote120 views1 answer
Show indices in mysql table
SQL
1 vote110 views1 answer
Error code 1055
SQL
5 votes106 views1 answer
Oracle get nls settings
SQL
0 vote128 views1 answer
Mariadb create index if not exists
SQL
-1 vote116 views5 answers
Online sql to linq generator
SQL