Skip to content

Instantly share code, notes, and snippets.

@Splaxi

Splaxi/DropAllViews.sql

Created September 17, 2019 07:28
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Splaxi/4eab92339ad23c5fdafa7a94487aae59 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Splaxi/4eab92339ad23c5fdafa7a94487aae59 to your computer and use it in GitHub Desktop.
Download ZIP
Drop all views
Raw
DropAllViews.sql
SELECT ' Drop view ' + s.NAME + '.' + v.NAME
FROM sys.views v
JOIN sys.schemas s
ON v.[schema_id] = s.[schema_id]
WHERE v.type = 'V'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment