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 helpAre there any code examples left?
New code examples in category SQL
Relative searches
how to modify constraint in sql
alter table constraint query
sql how to alter constraint
alter constraint in sql
how to alter table constraint in sql
sql alter table constraint
how to update a constraint in sql
how to alter column constraint in sql
alter table sql constraint
alter column constraint in sql
modify constraint in sql
sql alter constraint
alter table constraint sql
how to alter a columns constraint in sql
change constraint sql
alter constraint sql server
alter constraint
sql alter column constraint
alter constraint sql
alter table constraint
