SQL Server

Get all list of Stored Procedure from SQL Server database



 Like (1)  Dislike (0)

SQL Queries for getting the list of tables and Stored Procedures.

 
SELECT * FROM [dbRuInfo].INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE = 'PROCEDURE'
 
[dbRuInfo] : This is database name. 
 
 

0 Comment's

Comment Form

Submit Comment
If opportunity doesn’t knock, build a door.⛩

Popular Post

WPF

How to Use Logger in WPF Application

C-Sharp

Update Specific Users Out of Oce Settings C# with Example

C-Sharp

Retrieve Specified User''s Out of O ce Settings C# with Example

C-Sharp

Large Object Heap compaction C# with Example

C-Sharp

Weak References C# with Example

C-Sharp

Source code in the view C# with Example