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

2 votes177 views4 answers
Sql query interview questions
SQL
2 votes236 views3 answers
Postgres create view
SQL
0 vote169 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote172 views1 answer
Get primary key of table
SQL
0 vote227 views1 answer
Sqlalchemy query return only n results
SQL
2 votes192 views3 answers
Oracle show column of table
SQL
0 vote174 views1 answer
Apt install sql server
SQL
12 votes160 views2 answers
Delete all nodes neo4j
SQL
-1 vote161 views1 answer
Search all database tables for a value sqlserver
SQL
0 vote185 views1 answer
Mysql 5.6 hierarchical recursive query
SQL