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 vote375 views1 answer
Delete from IN subquery
SQL
3 votes378 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote358 views1 answer
How to find sql server installation folder
SQL
0 vote405 views1 answer
Calculer pourcentage mysql
SQL
0 vote346 views2 answers
How to prevent sql injection in java
SQL
4 votes280 views3 answers
Create table if not exists postgresql
SQL
5 votes341 views1 answer
How to get all table names in sql query
SQL
0 vote312 views1 answer
Mysql select last 15 minutes
SQL
0 vote323 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
0 vote335 views1 answer
Sql alchemy escape ; in insert statement
SQL