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

11 votes359 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote327 views1 answer
Mysql cast null to string
SQL
0 vote324 views1 answer
Database get 10 user aleatory
SQL
24 votes318 views4 answers
How to add column sql
SQL
0 vote347 views1 answer
C# mysql data reader from two tables
SQL
1 vote348 views1 answer
Round one decimal place mysql
SQL
4 votes322 views1 answer
Sql group by year
SQL
2 votes305 views1 answer
Sql find missing values between two tables
SQL
1 vote343 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote372 views1 answer
Python dictionary to sql update
SQL