Posted by dperiwal on 01/26/06 05:39

The following script may work for you::

--------------------------------------
IF OBJECT_ID('table01') IS NOT NULL
TRUNCATE TABLE table1

IF OBJECT_ID('table02') IS NOT NULL
TRUNCATE TABLE table2

....

IF OBJECT_ID('tableN') IS NOT NULL
TRUNCATE TABLE tableN
--------------------------------------

-- Damodar Periwal
Software Tree, Inc.
Simplify Data Integration
http://www.softwaretree.com

[Back to original message]