Get all list of Stored Procedure from SQL Server database



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