Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
 Posted - 2010-05-20 : 12:34:03
|
| I am unable to update table values in my test sql server 2005 database because the table values are referenced as foreign key in some other tableshow do I proceed with this scenario |
|
|
vijays3
Constraint Violating Yak Guru
354 Posts |
Posted - 2010-05-21 : 14:33:47
|
| you need to first modify your foreign key constraints ALTER TABLE MODIFY CONSTRAINT FORIEGN KEY(refering table column_name) REFERENCES refered_table (column_name) ON UPDATE CASCADE.then you will be able to update the column data. |
 |
|
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
Posted - 2010-05-27 : 12:22:47
|
| Thanks Vijay |
|
|
|
vijays3
Constraint Violating Yak Guru
354 Posts |
Posted - 2010-05-27 : 13:12:19
|
| you are welcome |
|
|
|
|
|
|
Updating table values