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.
⇒ Creating Stored Procedures with Statement Blocks in SQL Server
⇐ sys.procedures - Listing All Stored Procedures in SQL Server
2017-01-05, 1443🔥, 0💬
Popular Posts:
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...