Generate plan text for all dbs and views in a schema

Db_Show_plan.sql

SET NOCOUNT ON
GO

PRINT 'SET SHOWPLAN_TEXT ON'
PRINT 'GO'

DECLARE @query nvarchar(max)

DECLARE cur CURSOR FOR
SELECT  'SELECT * FROM [' + sys.schemas.name + '].[' + sys.objects.name + ']' AS [--stmt]
FROM         sys.objects INNER JOIN
                      sys.schemas ON sys.objects.schema_id = sys.schemas.schema_id
WHERE     (sys.objects.type = 'V')

OPEN cur

FETCH NEXT FROM cur INTO @query;
WHILE @@FETCH_STATUS = 0
BEGIN   
PRINT @query
FETCH NEXT FROM cur INTO @query;
END

CLOSE cur;
DEALLOCATE cur;

PRINT 'GO'
PRINT 'SET SHOWPLAN_TEXT OFF'
PRINT 'GO'