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, 5996🔥, 0💬
Popular Posts:
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...