How to rename a SQL Server table from within Visual Studio 2010

Posted on Saturday, July 14, 2012 at 7:15 AM into sql, database & code by Steve Woods.
Roughly a 1 minute read.

A fairly annoying quirk with Visual Studio 2010 Server Explorer is that it doesn't allow you to click on a table name to rename it - so here's how it's done.

• ?Right click the table you want to rename
• Select 'Open Table Definition' from the context menu
• When the table definition loads, go to the Properties pane, and find the (Name) property.
• Type the new name for your table (or press ESC to cancel editing)
• Job done