Shadab Shah (12/23/2012)
I create a table asCREATE TABLE DEMO (A INT)
Then i deleted it as follow
DELETE DEMO
I tried to again recreate the table using the same above statement, But it gave me the following error message
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'DEMO' in the database.
Now over here i am trying to understand when i deleted the table using delete how is it showing me the error message.
DELETE does not drop a table, it is used to delete records from a table. To drop a table you use DROP TABLE tablename;.