DECLARE @cmd NVARCHAR(max);

SELECT @cmd = STRING_AGG(CONCAT('SELECT TOP 1 * FROM ', TABLE_SCHEMA, '.', TABLE_NAME), CHAR(13))
  FROM INFORMATION_SCHEMA.VIEWS

EXEC(@cmd)

DECLARE @name VARCHAR(128) = ''
DECLARE @SQL VARCHAR(254)
DECLARE @schema VARCHAR(128)

WHILE EXISTS(SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'V' AND category = 0 AND [name] > @name ORDER BY [name])
BEGIN 
    SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'V' AND category = 0 AND [name] > @name ORDER BY [name]) 
    SELECT @schema = (SELECT TOP 1 schema_name(schema_id) FROM sys.views WHERE [name] = @name)
    SELECT @SQL = 'SELECT TOP 1 * FROM [' + @schema + '].[' + RTRIM(@name) +']' 
    EXEC (@SQL) 
    PRINT 'Dropped View: ' + @name 
END