mikaelweave/drop_view_if_exists.sql

Created April 7, 2015 18:06

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mikaelweave/f2c6893803d8fe5d9a5b.js"></script>
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