Skip to content

Instantly share code, notes, and snippets.

@mattmc3

mattmc3/drop_proc_if_exists.sql

Last active April 6, 2017 20:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mattmc3/3ec11ab210329e1929b156904b2ce770 to your computer and use it in GitHub Desktop.
Save mattmc3/3ec11ab210329e1929b156904b2ce770 to your computer and use it in GitHub Desktop.
Download ZIP
MSSQL drop proc if exists
Raw
drop_proc_if_exists.sql
if objectproperty(object_id('{{schema}}.{{proc_name}}'), 'IsProcedure') is not null drop proc {{schema}}.{{proc_name}}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment