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 vote163 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote143 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote153 views1 answer
Postgresql create table with boolean column
SQL
2 votes153 views1 answer
How to find constraints on a table in oracle
SQL
0 vote147 views1 answer
Uuid sqlalcomany
SQL
0 vote170 views1 answer
Mssql + bit + in python orm
SQL
0 vote146 views1 answer
Declare date variable sql
SQL
0 vote168 views1 answer
Test sql query
SQL
0 vote154 views1 answer
PostgreSQL types and C# types
SQL
-1 vote235 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL