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, 1225👍, 0💬
Popular Posts:
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...