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

5 votes106 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
4 votes95 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote102 views1 answer
Microsoft word insert sql code
SQL
0 vote105 views1 answer
SQL get max per id
SQL
0 vote102 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote185 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote124 views1 answer
Mysql preg replace
SQL
0 vote101 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
4 votes99 views2 answers
Sql table
SQL
0 vote107 views1 answer
Drop CHECK constraint sql
SQL