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

3 votes165 views1 answer
Postgresql if null then 0
SQL
0 vote192 views2 answers
Compound operator in sql
SQL
13 votes185 views2 answers
Get date from now() mysql
SQL
2 votes193 views1 answer
Apex execute batch job
SQL
0 vote179 views1 answer
Resullt all update knex mysql
SQL
1 vote175 views1 answer
Get table column names sql ssms
SQL
0 vote178 views1 answer
Drop tables from local database postgres pgadmin
SQL
2 votes197 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote235 views1 answer
Postgres foreign key multiple columns
SQL
-1 vote173 views1 answer
Search all database tables for a value sqlserver
SQL