Skip to content

Instantly share code, notes, and snippets.

@mikaelweave

mikaelweave/drop_view_if_exists.sql

Created April 7, 2015 18:06
Show Gist options
  • Save mikaelweave/f2c6893803d8fe5d9a5b to your computer and use it in GitHub Desktop.
Save mikaelweave/f2c6893803d8fe5d9a5b to your computer and use it in GitHub Desktop.
Download ZIP
Drop SQL View if it exists
Raw
drop_view_if_exists.sql
IF EXISTS(SELECT * FROM sys.views WHERE name = 'e_note' AND schema_id = SCHEMA_ID('dbo'))
DROP VIEW dbo.e_note
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment