HowTo: Rename SQL Tables in Visual Studio
The integration of SQL Servers in Visual Studio is really great. I use VS to create my SQL tables and simple administration stuff – it´s not often that I start SQL Management Studio. But one thing is really annoying: You can´t rename SQL Tables in VS! But there is a little trick to do that.
The context menu:
Unfortunately there is no "rename" button here and the name property is disabled.
The trick:
Just add the tables to an database diagram and rename it there and save it – that´s it.
I found this nice trick on this site – there are some cool features in the database diagram view.
About the author
Written by Code Inside Team
Currently there is no additional info about this author.
Abdalla
March 28, 2009
Can’t you rename it by using “F2″ key while selecting the tablename node from the tree ? Never tried myself though so I could be wrong!
cguillemette
February 15, 2010
This is great thanks!
I tried using ALTER TABLE clause with RENAME TO and it didn’t work. I think the way you propose is the only way.
HninKyawtWai
May 18, 2010
Please copy this table to new table name and then delete old table.
Query
=====
insert into New_TableName
select *
from Old_TableName
Shabi
March 17, 2011
Thanksssssssssssssss!!
Was going nuts on this small but so important thingy
hidden input
July 19, 2011
1. In Server Explorer, right-click the table you want to rename and choose Open Table Definition from the shortcut menu.
The table opens in the Table Definition window of Table Designer.
2. Right-click the table in the Table Definition window and choose Properties from the shortcut menu.
3. In the field for the Name value in the Properties window, type a new name for the table.
4. To cancel this action, press the ESC key before leaving this field.
5. From the File menu choose Save table name.
Here is the direct link
http://msdn.microsoft.com/en-us/library/bw5xhetd.aspx