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 vote373 views1 answer
Oracle table free space
SQL
1 vote332 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote350 views1 answer
Initcap in mysql
SQL
0 vote384 views1 answer
Mysql where don't have string
SQL
21 votes377 views3 answers
Sql server search column name in all tables
SQL
4 votes317 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
5 votes341 views2 answers
Mysql drop table cascade
SQL
-1 vote350 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote339 views1 answer
Groupby error in mysql
SQL
0 vote368 views1 answer
Sql order by except one row
SQL