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