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