Collections:
"DROP PROCEDURE" - Dropping an Existing Procedure in SQL Server
How To Drop an Existing Stored Procedure in SQL Server Transact-SQL?
✍: FYIcenter.com
If you have an existing procedure that you don't want to use it anymore, you should delete it from the SQL Server by using the "DROP PROCEDURE" statement as shown in the tutorial example below:
USE FyiCenterData; GO DROP PROCEDURE datetime; GO Command(s) completed successfully. SELECT * FROM sys.procedures; GO Name object_id schema_id type type_desc ---------- ----------- ----------- ---- -------------------- Hello 1621580815 1 P SQL_STORED_PROCEDURE date 1653580929 1 P SQL_STORED_PROCEDURE (2 row(s) affected)
Stored procedure "datetime" is no longer in the database.
Â
2017-01-05, 1103👍, 0💬
Popular Posts:
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...