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