Clearing tables

From: "Chris Lieb" <ChrisLieb@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 18 May 2005 10:59:17 -0700

Which is the more efficient way to clear the contents of a table:
DELETE FROM tableName
TRUNCATE TABLE tableName
Or DROP the table then create it again?

--
Chris Lieb
UPS CACH, Hodgekins, IL
Tech Support Group - Systems/Apps
.

Follow-Ups:
- Re: Clearing tables
  - From: Hari Prasad

Prev by Date: query multi tables, count/sum 1 of the tables
Next by Date: Re: Clearing tables
Previous by thread: query multi tables, count/sum 1 of the tables
Next by thread: Re: Clearing tables
Index(es):
- Date
- Thread

Relevant Pages

Re: OT: Teusday Titilation
... open Q/A, connect to db containing logs, truncate table tablename, ... CTRL +E, crisis averted... ...
(microsoft.public.cert.exam.mcse)
Re: OT: Teusday Titilation
... open Q/A, connect to db containing logs, truncate table tablename, CTRL +E, ... The InterNeil MCNGP Triple X ...
(microsoft.public.cert.exam.mcse)
Error 1934 Severity 16 State 1
... SQL Server 2000 Standard Sp3. ... TRUNCATE TABLE IBFF_BOL_Temp ... declare cur CURSOR ... dbcc dbreindex (@tablename) ...
(microsoft.public.sqlserver.server)
Re: truncate tables in my tablespace
... My intention is the thro all the data away so would delete from ... tablename have the same restriction with constraints as truncate? ... Plus, TRUNCATE ...
(comp.databases.oracle.server)
Re: Clearing tables
... I will go with TRUNCATE TABLE ... Hari ... SQL Server MVP ... > TRUNCATE TABLE tableName ...
(microsoft.public.sqlserver.mseq)