create procedure sys.sp_MSdropview_internal
@viewname sysname
as
declare @command nvarchar(1000)
declare @owner sysname
if OBJECT_ID(@viewname, 'V') is not NULL
begin
select @owner = TABLE_SCHEMA from INFORMATION_SCHEMA.VIEWS where TABLE_NAME = @viewname
set @command = 'drop view ' + quotename(@owner) + '.' + quotename(@viewname)
exec (@command)
if @@ERROR <>0
begin
return (1)
end
end
return 0