Sql Server Management studio drop table and re-create issue

Question

I have created a table with primary key and foreign key using SQL Server Management studio 2008R2, then I have drop the table using the sql command drop table nameofthetable and the table has been dropped. After that I have created another table with the same name of the dropped table but I get this error:

" The table 'name of my table' already exists'.

Why? I don't see the old table in my table list.

Can you help me, I need to create the table with this name?

score 1 · Answer 1 · edited May 23 '17 at 12:25

1

Commit your changes before you recreate the table. You can also use the GO statement.

edited May 23 '17 at 12:25

Community

1
1

answered Aug 15 '13 at 17:15

BartoszKP

34,786
15
102
130

score 0 · Answer 2 · answered Aug 15 '13 at 17:23

0

In the Object Explorer, right-click and Refresh the Tables list

answered Aug 15 '13 at 17:23

BWS

3,786
18
25

i resolved the issue closing management studio and reopening it – ezechiele2517 Aug 15 '13 at 18:04
that would do it as well ... but, the refresh will avoid having to do that in the future. – BWS Aug 15 '13 at 18:05
@BWS Closing all tabs is necessary before you refresh the tables. – Hamzeh Soboh Nov 08 '13 at 11:42

Sql Server Management studio drop table and re-create issue

2 Answers2