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 vote268 views1 answer
Select 1 from orders
SQL
2 votes263 views5 answers
Eloquest how to select one specific column in database
SQL
1 vote271 views1 answer
Mysql show database size in mb
SQL
0 vote281 views1 answer
Create table with primary key and foreign key in sql server
SQL
16 votes305 views1 answer
Sqlserver add column to table
SQL
3 votes284 views1 answer
APEX elapsed time
SQL
1 vote274 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
1 vote268 views3 answers
Mysql connection string
SQL
0 vote222 views0 answer
SQL
9 votes263 views4 answers
How to create new user and database postgresql in ubuntu
SQL