CREATE TableList (view)

by 
DECLARE @strSQL varchar(MAX)

IF Object_id(N'[util].[TableList]', 'V') IS NOT NULL
DROP VIEW [util].[TableList];


SET @strSQL = N''
SET @strSQL = @strSQL 
		+ 'CREATE VIEW [util].[TableList] AS '
		+ 'SELECT '
		+ ' ROW_NUMBER() OVER(ORDER BY s.name, o.name ASC) AS RowNum,'
				+ ' s.name as [schema_name],o.*
FROM sys.objects o
INNER JOIN sys.schemas s ON o.schema_id = s.schema_id
WHERE type = ' + char(39) +'U' + char(39)


	EXEC (@strSQL);

Leave a Comment