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 vote158 views2 answers
Avg() sql
SQL
2 votes160 views1 answer
Oracle current date without time
SQL
25 votes194 views5 answers
Date in mysql
SQL
0 vote217 views1 answer
Sql server delete records with specific date
SQL
49 votes267 views6 answers
Get duplicate records in sql
SQL
0 vote186 views1 answer
Mysql sql.gz
SQL
1 vote199 views1 answer
Sql current timestamp
SQL
0 vote319 views1 answer
Generate a random otp in sql server
SQL
2 votes195 views3 answers
Replace null in sql
SQL
16 votes185 views4 answers
Ascending order mysql
SQL