Take the tour ×  What is the easiest and most reliable approach
to rename the database tables and columns in SQL Server 2008 r2?
We have finished development and for some reasons, we are
required to rename some tables and afew columns.  Is using
synonyms the good way of doing that? What are the pitfalls we
should be prepared for? Does it help in renaming the columns
gracefully as well?  We have a lot of scripts related to these
tables and also they are referenced in the application by .net
developers.  share|improve this question Is the intention to
rename these database objects and provide a facade so that
existing apps do not need to be modified to use the new object
names? –  billinkc Oct 11 '12 at 21:35 add comment  2 Answers
up vote 4 down vote accepted  I think the approach depends on
whether the application(s) are live or if you are still testing.
For tables, the safest approach is to create a synonym using the
new name. This way you can change the app(s) one at a time (or
even one reference at a tim