List of all views and scripts to create

Here is a script to list all views in a database and provide the script to create them.  This helps when moving views to new environments.
SELECT AS VIEW_NAME, LEFT(b.definition, 4000) AS SQL1, SUBSTRING(b.definition, 4001, 4000) AS SQL2, LEN(b.definition) AS SQL_Length 
FROM sys.sql_modules AS b 
INNER JOIN sys.views AS a ON b.object_id = a.object_id 

posted @ Friday, October 4, 2013 12:32 PM


Comments on this entry:

No comments posted yet.

Your comment:

 (will not be displayed)

Please add 6 and 5 and type the answer here:

Live Comment Preview: