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 vote367 views1 answer
Mariadb case switch
SQL
25 votes362 views6 answers
Change column name mysql
SQL
1 vote374 views1 answer
Spark sql convert string to date
SQL
0 vote358 views1 answer
Mysql two joins
SQL
3 votes433 views1 answer
Where id is in list sql
SQL
0 vote392 views1 answer
Select distinct after join
SQL
0 vote378 views1 answer
Copying query result to excel
SQL
0 vote353 views1 answer
Sqlalchemy case insensitive like
SQL
5 votes334 views3 answers
Truncate function in sql oracle
SQL
0 vote381 views1 answer
Plsql find location of procedure
SQL