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 vote180 views1 answer
Having all mysql
SQL
0 vote126 views1 answer
Add colum date in sql
SQL
1 vote138 views1 answer
Ef core 5.0 usesqlserver not found
SQL
1 vote125 views2 answers
Mysql current user
SQL
1 vote124 views4 answers
Between vs in sql
SQL
1 vote135 views1 answer
Postgres concat_ws
SQL
6 votes126 views5 answers
Alter table oracle
SQL
0 vote89 views1 answer
Delete all rows from table sqlite
SQL
0 vote143 views1 answer
Duplix print in Smartforms
SQL
-1 vote143 views1 answer
Mysql select all columns and specific fields as
SQL