title: How can I drop a table if it exists in SQL Server 2000?
body: <p>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.  </p>
  
  <p>Is there something like "if exists" for SQLServer 2000 like in MySQL?</p>
  
  <p>thanks.</p>