Collections:
sys.procedures - Listing All Stored Procedures in SQL Server
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL?
✍: FYIcenter.com
If you want to see a list of stored procedures in your current database, you can use the system view, sys.procedures as shown in this tutorial exercise:
USE FyiCenterData; GO 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 datetime 1669580986 1 P SQL_STORED_PROCEDURE (3 row(s) affected)
⇒ "DROP PROCEDURE" - Dropping an Existing Procedure in SQL Server
⇐ EXECUTE - Executing Stored Procedures in SQL Server
2017-01-05, 6008🔥, 0💬
Popular Posts:
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...