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