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 |
|
SQLSeeker
Starting Member
15 Posts |
 Posted - 2009-12-22 : 08:33:51
|
| Hi, In my database I have 3 tables with same schema with different names. When I alter one table, I want same changes to other two also.How can I achieve this without altering other two manually.Thanks |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2009-12-22 : 09:49:38
|
| We use Red Gate's SQL compare Tool. http://www.red-gate.comI don't know of anyway in SSMS except if you altered the first table with an SQL command, then apply that same command to the other 2 tables. |
 |
|
|
shan
Yak Posting Veteran
84 Posts |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
|
|
|
|
|
Alter Table