InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 01:26:52 GMT20http://www.sqlservercentral.com/Forums/Topic1399787-392-1.aspxWhen you run DELETE, every row will be removed from the table.TRUNCATE TABLE statement also removes all rows from a table. TRUNCATE TABLE has several advantages over DELETE, when used to remove all rows from a table. TRUNCATE TABLE uses less transaction log space, requires fewer locks, and leaves zero pages for the table.BUT Delete or Truncate does not remove Objects completely.Use DROPinstead of Delete or Truncate.use DROP TABLE DEMO instead of Delete or TruncateSun, 23 Dec 2012 23:18:04 GMThcprasadvhttp://www.sqlservercentral.com/Forums/Topic1399787-392-1.aspxLynn is correct. If you need to remove the table, you need to use DROP. If you are only trying to remove records, then DELETE is what you will use.Sun, 23 Dec 2012 22:54:42 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1399787-392-1.aspx[quote][b]Shadab Shah (12/23/2012)[/b][hr]I create a table as [code="sql"]CREATE TABLE DEMO (A INT)[/code]Then i deleted it as follow[code="sql"]DELETE DEMO[/code]I tried to again recreate the table using the same above statement, But it gave me the following error message[b]Msg 2714, Level 16, State 6, Line 1There is already an object named 'DEMO' in the database.[/b]Now over here i am trying to understand when i deleted the table using delete how is it showing me the error message.[/quote]DELETE does not drop a table, it is used to delete records from a table. To drop a table you use DROP TABLE tablename;.Sun, 23 Dec 2012 22:29:50 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1399787-392-1.aspxI create a table as [code="sql"]CREATE TABLE DEMO (A INT)[/code]Then i deleted it as follow[code="sql"]DELETE DEMO[/code]I tried to again recreate the table using the same above statement, But it gave me the following error message[b]Msg 2714, Level 16, State 6, Line 1There is already an object named 'DEMO' in the database.[/b]Now over here i am trying to understand when i deleted the table using delete how is it showing me the error message.Sun, 23 Dec 2012 19:48:12 GMTShadab Shah