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 vote226 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote218 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
1 vote218 views1 answer
Postgresql filter on
SQL
1 vote246 views3 answers
Sql procedure
SQL
0 vote237 views1 answer
Oracle list datafiles
SQL
1 vote234 views1 answer
Query for all indexes in table postgres
SQL
0 vote272 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote225 views1 answer
Hw to delete a procedure in pl sql
SQL
1 vote223 views4 answers
Postgres extract date from timestamp
SQL
0 vote225 views4 answers
Sql server date format yyyy-mm-dd
SQL