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

3 votes445 views1 answer
Oracle cannot access v$session
SQL
1 vote324 views3 answers
Remove unique key from a table
SQL
0 vote328 views1 answer
Sql get table last modified time
SQL
0 vote353 views1 answer
Oracle temporary table
SQL
-1 vote336 views1 answer
Sql add column bit
SQL
0 vote298 views1 answer
'0000-00-00' for column '
SQL
0 vote401 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote342 views1 answer
Show database not empty tables postgres
SQL
0 vote370 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote370 views2 answers
Create row number in sql
SQL