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 |
|
scottlucas58
Starting Member
8 Posts |
 Posted - 2009-09-01 : 13:10:31
|
| if i rename a column, do i have to drop and re-create any indexes that used that column? Any other gotchas?-s |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2009-09-01 : 17:13:46
|
| If you rename a column, no need to drop and recreate indexes on that column |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-09-01 : 17:32:55
|
| If you have code that references that column (stored procedures, functions, application code) you'll need to change them. |
|
|
|
scottlucas58
Starting Member
8 Posts |
Posted - 2009-09-01 : 17:55:54
|
| awesome! thanks.-s |
|
|
|
|
|
|
renaming a column