Posted by rdraider on 01/26/06 01:41

Hi,
I am trying to create a script that deletes transaction tables and leaves
master data like customer, vendors, inventory items, etc. How can I use
TRUNCATE TABLE with an Exists? My problem is I have 200+ tables, if I
simply use a list like:
truncate table01
truncate table02
truncate table03
....

I get errors if the table does not exist and have to manually run the
truncate statements. Some tables may not exist if that part of the app is
never used. I'm trying to make a list of all tables that could exist
without it erroring out 50+ times.

Thanks in advance.

• Next in forum: select cast help needed
• Prev in forum: Re: SQL Server does not exist or access denied
• Thread view: Truncate table if exists

[Reply to this message]