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 vote187 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote161 views1 answer
Import csv to mysql
SQL
1 vote185 views1 answer
Restart identity postgresql
SQL
3 votes193 views1 answer
Sql server check version
SQL
0 vote233 views1 answer
ALV GRID events
SQL
0 vote193 views1 answer
Sql pad left 0
SQL
0 vote191 views1 answer
Sql recherche nom prenom
SQL
0 vote240 views1 answer
How to input data as id in database sql c#
SQL
16 votes249 views6 answers
Insert sql
SQL
16 votes272 views6 answers
Mysql find duplicates in same table
SQL