SQL Server: drop table

Checking if table exists

If a table exists can be checked with object_id. Thus, it's possible to drop a table before it is (re-) created:

if object_id('tq84_tab', 'U') is not null drop table tq84_tab;

create table tq84_tab (
  id integer primary key,
  val varchar(10)
);

Checking for the existence of a table and droping it can be executed in one go:

DROP TABLE IF EXISTS tq84_tab;