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 vote318 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote305 views1 answer
Set root password mysql xampp
SQL
4 votes286 views1 answer
Check database name postgresql
SQL
0 vote290 views2 answers
Getting customers with no orders sql
SQL
0 vote308 views1 answer
Sql last 3 rows
SQL
2 votes308 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
7 votes288 views1 answer
Set sequence value oracle
SQL
1 vote303 views1 answer
Mysql event last execution
SQL
1 vote283 views1 answer
Sql oracle update multiple rows
SQL
0 vote304 views1 answer
Postgres populate table from another table
SQL