sp_drop

if exists(select * from sys.objects where object_id = OBJECT_ID(N'dbo.sp_drop') and type in (N'P'))
	DROP PROCEDURE sp_drop;
GO

CREATE PROCEDURE sp_drop
	@type nvarchar(2),
	@name nvarchar(200)
AS
BEGIN
	set nocount on;

	IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(@name) AND type in (@type))
		BEGIN
			declare @t nvarchar(20)
			if @type = N'U'
				set @t = N'table'
			else if @type = 'V'
				set @t = N'view'
			else if @type = N'P'
				set @t = N'procedure';
			
			declare @sql nvarchar(200)

			set @sql = N'drop ' + @t + N' ' + @name

			exec sp_executesql @sql
		END
END
GO