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 vote282 views1 answer
Create dabase postgresql
SQL
1 vote214 views1 answer
Oracle create program if no exists
SQL
12 votes259 views2 answers
Update column data type postgres
SQL
0 vote201 views1 answer
Wordpress sql change site url
SQL
0 vote377 views1 answer
Install mysql on bash
SQL
0 vote212 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
7 votes203 views4 answers
How to reset the identity column in sql server
SQL
0 vote233 views1 answer
Sql developer sql worksheet not showing
SQL
14 votes250 views3 answers
Inner join sql oracle
SQL
0 vote202 views1 answer
Mariadb cast to int
SQL