alter constraint in sql

Solutions on MaxInterview for alter constraint in sql by the best coders in the world

showing results for - "alter constraint in sql"

1You can not alter constraints ever but you can drop them and then recreate.
2
3Have look on this
4
5    ALTER TABLE your_table DROP CONSTRAINT ACTIVEPROG_FKEY1;
6
7and then recreate it with ON DELETE CASCADE like this
8
9    ALTER TABLE your_table
10    add CONSTRAINT ACTIVEPROG_FKEY1 FOREIGN KEY(ActiveProgCode) REFERENCES PROGRAM(ActiveProgCode)
11        ON DELETE CASCADE;
12hope this help

similar questions

sql server alter column updating values in sql sql update with statement sql alter column how to update values in sql update in sql add constraint sql how to update data in sql how to update row in sql how to change the value of a table in sql sql change column in existing table sql statement to change a field value change primary key sql sql alter table t sql update table variale change row in sql

queries leading to this page

alter sql constraint sql alter column constraint change constraint in sql how to alter constraint in sql alter constraint in sql server how to modify constraint in sql alter constraint sql alter table update constraint alter table constraint query alter table constraint sql how to alter table constraint in sql sql how to alter constraint alter the constraint of a table in sql how to alter a columns constraint in sql alter constraint column sql alter column constraint in sql alter table constraint how to update a constraint in sql alter table sql constraint alter constraint sql server modify constraint in sql edit constraint sql alter constraint in sql how to edit constraint in sql sql alter table constraint sql alter constraint change constraint sql how to alter column constraint in sql alter constraint sql alter constraint in sql