create table TEST_TABLE
(
TEST_COLUMN int
)
drop table TEST_TABLE
IF OBJECT_ID('TEST_TABLE','U') is not null begin drop table TEST_TABLE end
How to drop table if exists in SQL Server 2005?
SQL Server: Check if table exists
EXISTS (Transact-SQL)
OBJECT_ID (Transact-SQL)