>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 > >