How can I drop a table if it exists in SQL Server 2000?

Question

I have a DTS package that drops a table then creates it and populates it but sometimes something happens and the package fails after the drop table. If it's rerun it fails cuz the table hasn't been created yet.

Is there something like "if exists" for SQLServer 2000 like in MySQL?

thanks.

Answer 1

Or quicker:

IF OBJECT_ID('temp_ARCHIVE_RECORD_COUNTS') IS NOT NULL  
  DROP TABLE temp_ARCHIVE_RECORD_COUNTS  

• OBJECT_ID - MSDN Reference - SQL Server 2000
• OBJECT_ID - MSDN Reference - SQL Server 2008