I always found it a pain that you couldn't rename a table using Server Explorer in Visual Studio. Right-clicking the table does not offer it as an option. You could of course run an SQL Script but lifes too short for that, so I often used Entprise Manager/Management Studio instead.
However I just found this neat trick which certainly works for VS2005/SQL2005 - not tried it with other combinations:
- Create/Open a database diagram
- Add the table you want to rename
- Select the table, change the (Name) property in the properties window and save
HTH
Ian
Comments are disabled for this blog - but please feel free to comment via the contact page