emptying an MSSQL table

[Guy Werry]

Viet,

I know from my experience with SQL and Oracle that deletes are slow because the indexes are being re-built as the deletions happen.

In SQL/Oracle there is a TRUNCATE TABLE command that empties a table very efficiently ... unfortunately, I don't know is MSSQL has an equivalent.  

Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited. 

-----Original Message-----
From: powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com
[mailto:powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com]On Behalf Of
Viet Nguyen
Sent: Tuesday, April 11, 2006 11:00 AM
To: powerh-l at lists.sowder.com
Subject: emptying an MSSQL table


Could someone tell me which command I can use to empty out an MSSQL
table using Powerhouse QTP? I am using delete from table but it seems
slow on large files.
Thanks.



-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.