Archive | December, 2012

SQL Query for geting all Stored Procedure under a schema

10 Dec

 SELECT *
FROM DB_Name.information_schema.routines
WHERE routine_type = ‘PROCEDURE
AND SPECIFIC_SCHEMA=’SchemaName

Using this query we can get all the stored procedure under  SchemaName in DB_Name