How to check if a stored procedure exists before creating it

by

I realize this has already been marked as answered, but we used to do it like this:

IF NOT EXISTS (SELECT * FROM sys.objects WHERE type="P" AND OBJECT_ID = OBJECT_ID('dbo.MyProc'))
   exec('CREATE PROCEDURE [dbo].[MyProc] AS BEGIN SET NOCOUNT ON; END')
GO

ALTER PROCEDURE [dbo].[MyProc] 
AS
  ....

Just to avoid dropping the procedure.

More Related Contents:

  1. Insert results of a stored procedure into a temporary table
  2. Function vs. Stored Procedure in SQL Server
  3. SQL Server – How to lock a table until a stored procedure finishes
  4. What is a stored procedure?
  5. How to assign an exec result to a sql variable?
  6. SQL Server SELECT into existing table
  7. Stored procedure that exports data into csv files only exports to one file
  8. Inserting rows into a table with one IDENTITY column only [duplicate]
  9. Eliminate and reduce overlapping date ranges
  10. Is it possible to write single query on two table which are not connected to each other?
  11. How to create a specific SQL Server stored procedure? [closed]
  12. Should I use != or for not equal in T-SQL?
  13. How to update two tables in one statement in SQL Server 2005?
  14. Create a date from day month and year with T-SQL
  15. How should I pass a table name into a stored proc?
  16. Creating an index on a table variable
  17. OR is not supported with CASE Statement in SQL Server
  18. Parse comma-separated string to make IN List of strings in the Where clause
  19. How do I execute a stored procedure once for each row returned by query?
  20. Sequence vs identity
  21. How to update and order by using ms sql
  22. How to store image in SQL Server database tables column [duplicate]
  23. Procedure or function !!! has too many arguments specified
  24. SQL “between” not inclusive
  25. Can I set ignore_dup_key on for a primary key?
  26. SQL Server replace, remove all after certain character
  27. How to find column names for all tables in all databases in SQL Server
  28. SQL Row_Number() function in Where Clause
  29. When using GETDATE() in many places, is it better to use a variable?
  30. Cumulative Total in MS Sql server [duplicate]

Leave a Comment