Home Forums SQL Server 2008 T-SQL (SS2K8) Something fissy about DELETE RE: Something fissy about DELETE

  • December 23, 2012 at 10:29 pm

    #1571221

    Shadab Shah (12/23/2012)

    I create a table as CREATE 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;.