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

1 vote127 views1 answer
How to run sql script
SQL
0 vote146 views2 answers
Oracle create chain rule
SQL
0 vote156 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
1 vote152 views1 answer
How to drop function in sql
SQL
0 vote143 views1 answer
Cast for print sql
SQL
3 votes183 views1 answer
Export postgres database linux
SQL
1 vote144 views3 answers
Postgresql connect to database
SQL
0 vote147 views1 answer
Mysql begin statement
SQL
0 vote146 views1 answer
Find usage of table in sql server
SQL
3 votes150 views1 answer
Oracle transaction commit rollback example
SQL