HowTo: Rename SQL Tables in Visual Studio

imageThe 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:

image

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.

kick it on DotNetKicks.com

2 Comments so far »

  1. Dew Drop - March 26, 2009 | Alvin Ashcraft's Morning Dew said

    am March 26 2009 @ 3:25 pm

    [...] HowTo: Rename SQL Tables in Visual Studio (Robert Muehsig) [...]

  2. Abdalla said

    am March 28 2009 @ 10:09 pm

    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!

Comment RSS · TrackBack URI

Leave a comment

Name: (Required)

eMail: (Required)

Website:

Comment: