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


Please consider what you post!
Chillax if you're angry.