OBJECT_ID check temp table existance

by Ivan Gerasimenko

JavaScript

CREATE TABLE #tb
(
	Id INT IDENTITY(1,1) PRIMARY KEY
);
RAISERROR ('#tb has been created', 0, 1) WITH NOWAIT;


IF OBJECT_ID('tempdb..#tb') IS NOT NULL 
BEGIN
	DROP TABLE #tb;
	RAISERROR ('#tb has been droped', 0, 1) WITH NOWAIT;
END



--DROP TABLE #tb;