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 |
|
uniquegodwin
Starting Member
12 Posts |
 Posted - 2007-07-13 : 05:34:09
|
| Hello everyone,I have a situation where I have about 40 tables according to a database plan in which there maybe addition/deletions of columns in future.I have upto 5 primary key's in some tables.When a paticular column needs to be changed,I need to change the whole database due to the primary key's.What is the best way to make things simpler?Please help me,Thanks,Godwin |
|
|
bpgupta
Yak Posting Veteran
75 Posts |
Posted - 2007-07-13 : 05:45:15
|
| Try to update cascade updated .For more information use BOL. |
 |
|
|
|
|
|
Database design