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)
Â
2017-01-05, 4675👍, 0💬
Popular Posts:
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
What Do You Need to Connect PHP to MySQL in MySQL? If you want to access MySQL database server in yo...
How To Display a Past Time in Days, Hours and Minutes in MySQL? You have seen a lots of Websites are...