T-SQL Script: Generate DROP + CREATE for all views
T-SQL Script: Generate If Exists then DROP + CREATE for all views
SELECT
'IF EXISTS (SELECT 1 FROM sys.views WHERE object_id = OBJECT_ID('''
+ QUOTENAME(s.name) + '.' + QUOTENAME(v.name) + '''))
DROP VIEW ' + QUOTENAME(s.name) + '.' + QUOTENAME(v.name) + ';'
AS DropStatement,
m.definition AS CreateStatement
FROM sys.views v
JOIN sys.sql_modules m ON v.object_id = m.object_id
JOIN sys.schemas s ON v.schema_id = s.schema_id;
'IF EXISTS (SELECT 1 FROM sys.views WHERE object_id = OBJECT_ID('''
+ QUOTENAME(s.name) + '.' + QUOTENAME(v.name) + '''))
DROP VIEW ' + QUOTENAME(s.name) + '.' + QUOTENAME(v.name) + ';'
AS DropStatement,
m.definition AS CreateStatement
FROM sys.views v
JOIN sys.sql_modules m ON v.object_id = m.object_id
JOIN sys.schemas s ON v.schema_id = s.schema_id;