I use a sql script to create table
At the beginning of my script, I will always delete the table and then create table and insert data.
When I run the 2nd time, I got the below error and I can not see my table (look as if hidden) in my database from the object explorer panel of SMSS
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'My Table' in the database.
(3306 row(s) affected)
Can anyone know what is happening. I have been using the same procedure for creating other table. I try to rename MyTable to other name nothing change.
Here is my SQL script