Re: Clearing tables

From: "Hari Prasad" <hari_prasad_k@xxxxxxxxxxx>
Date: Thu, 19 May 2005 00:42:53 +0530

Hi,

I will go with TRUNCATE TABLE <Table Name>

Thanks
Hari
SQL Server MVP

"Chris Lieb" <ChrisLieb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E6085077-8B80-4573-B40D-E9837967B463@xxxxxxxxxxxxxxxx
> 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

.

References:
- Clearing tables
  - From: Chris Lieb

Prev by Date: Clearing tables
Next by Date: Re: query multi tables, count/sum 1 of the tables
Previous by thread: 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: Reseting Identity Seed
... Tibor Karaszi, SQL Server MVP ... > I want to reset the identity seed value for a table... ... it does not allow to truncate the table... ...
(microsoft.public.sqlserver.server)