Delete Objects by Prefix

DECLARE @SQL VARCHAR(1000)
DECLARE @tempName VARCHAR(1000)
DECLARE @count VARCHAR(1000)
select @count = COUNT(*) from dbo.sysobjects where type = 't' and name like '[Table_Prefix]%'
while @count > 0
Begin
Select @tempName = name from dbo.sysobjects where type = 't' and name like '[Table_Prefix]%'
exec('drop table ' + @tempName)
set @count = @count - 1
END

DECLARE @SQL VARCHAR(1000)
DECLARE @tempName VARCHAR(1000)
DECLARE @count VARCHAR(1000)
select @count = COUNT(*) from dbo.sysobjects where type = 'p' and name like '[Stored_Procedure_Prefix]%'
while @count > 0
Begin
Select @tempName = name from dbo.sysobjects where type = 'p' and name like '[Stored_Procedure_Prefix]%'
exec('drop table ' + @tempName)
set @count = @count - 1
END