USE [GretDB]

--Проверка наличия и удаление таблицы

IF not OBJECT_ID(N'dbo.DelPJI','U') IS NULL

DROP TABLE dbo.DelPJI

--http://www.sql.ru/forum/681604/proverka-sushhestvovaniya-tablicy

--\\============================================================

IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME='TableName' AND xtype='U')

/*сделать то-то*/

--\\============================================================

IF OBJECT_ID(N'ИмяТаблицы','U') IS NULL

PRINT 'Таблицы [ИмяТаблицы] не существует!'

ELSE

PRINT 'Есть таблица [ИмяТаблицы].';

--\\сравните планы=============

SELECT * FROM SYSOBJECTS WHERE NAME='TableName' AND xtype='U'

select object_id('TableName')

--\\============================================================

--http://www.sql.ru/forum/741690/proverka-na-sushhestvovanie-vremennoy-tablicy-i-ee-udalenie

if object_id('tempd..#table') is not null drop table #table