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

• Next in forum: Re: select cast help needed
• Prev in forum: select cast help needed
• Thread view: Re: Truncate table if exists

[Reply to this message]