This was the long thread on this topic Function To Test For Table Doesn't Work Thread #1328338

>Why doesn't this work for temp tables?
>
>

>USE rbp_test
>GO
>
>--DROP PROCEDURE sp_DropTable
>
>GO
>
>CREATE PROCEDURE sp_DropTable
>	@TableName		VARCHAR(50)
>AS
>
>
>	IF EXISTS 
>		(SELECT 1 
>			FROM INFORMATION_SCHEMA.TABLES 
>			WHERE TABLE_TYPE='BASE TABLE' AND 
>				  TABLE_NAME = @TableName) 
>		
>		BEGIN
>		
>			DECLARE @Command VARCHAR(100)
>			SET @Command = 'DROP TABLE ' + @TableName
>		
>			EXECUTE (@Command);
>		END
>
>