Create View From All Tables In a DB

CreateViewFromAllTablesInaDB.sql

https://stackoverflow.com/questions/23166423/how-to-create-view-for-all-tables-in-database

 
DECLARE @SQL nvarchar(MAX)
SET @SQL = N''

SELECT
    @SQL = @SQL + 
    N'IF EXISTS(SELECT 1 FROM sys.objects WHERE name = ''v_' + t.[TABLE_NAME] + ''' AND type = ''V'') BEGIN DROP VIEW [v_' + t.[TABLE_NAME] + '] END 
	EXEC(''CREATE VIEW [v_' + t.[TABLE_NAME] + N'] AS SELECT ' + 
        STUFF(
            (SELECT distinct ',' + c.[COLUMN_NAME]
               FROM [INFORMATION_SCHEMA].[COLUMNS] AS c
               WHERE c.[TABLE_SCHEMA] =t.[TABLE_SCHEMA] and c.[TABLE_NAME]=t.[TABLE_NAME]
               FOR XML PATH(''), TYPE).value('.','nvarchar(max)')
        ,1,1,'')
        + ' FROM [' + t.[TABLE_NAME] + '] '') 
'
	 
FROM [INFORMATION_SCHEMA].[TABLES] t
WHERE [TABLE_TYPE]='BASE TABLE' 
 

 EXEC sp_executesql @SQL

--print @SQL