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, 8746🔥, 0💬
Popular Posts:
What Is Transport Network Substrate (TNS) in Oracle? TNS, Transport Network Substrate, is a foundati...
What Are the Differences between BINARY and VARBINARY in MySQL? Both BINARY and VARBINARY are both b...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Concatenate Two Binary Strings Together in SQL Server Transact-SQL? SQL Server 2005 allows to...