Wednesday, April 24, 2013

SWBUG: MS SQL Server Management Studio 2008 - Renaming table

1. Create table A
2. Rename table A to table B
3. Create new table, and name it table A

This causes an error that table already exists. Even if you refresh the table list, you will see that table A does not exist and table B exists. I cannot create a new table named Table A. Closing and reopening the Management Studio corrects this problem.