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, 4148👍, 0💬
Popular Posts:
How To Count Duplicated Values in a Column in SQL Server? If you have a column with duplicated value...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...