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, 6036🔥, 0💬
Popular Posts:
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...