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 vote98 views0 answer
SQL
0 vote154 views1 answer
Get enginge db mysql
SQL
0 vote147 views1 answer
Trigger stock phpmyadmin output message
SQL
4 votes125 views1 answer
Search column by name mysql
SQL
-1 vote87 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote149 views1 answer
How to get nth number in sql
SQL
2 votes151 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote105 views1 answer
Sqlalchemy existing database
SQL
0 vote157 views2 answers
Mysql row_number() example
SQL
0 vote136 views1 answer
Mysql timediff
SQL