Skip to content
  • There are no suggestions because the search field is empty.

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;