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 vote340 views1 answer
Sql select column name like from multiple tables
SQL
0 vote337 views2 answers
How to prevent sql injection in java
SQL
0 vote313 views1 answer
How to select even id in sql
SQL
0 vote337 views3 answers
Run sql command line
SQL
0 vote305 views3 answers
Between keyword sql
SQL
8 votes344 views1 answer
Oracle current date plus 1 month
SQL
0 vote362 views1 answer
Fetching data from mysqldb
SQL
0 vote322 views1 answer
Regex any word except sql
SQL
3 votes317 views3 answers
Create table in microsoft sql server
SQL
6 votes318 views2 answers
Mysql get yesterday
SQL