Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
14 lines (13 sloc) 386 Bytes
-- Script: Get-Proc.sql
-- Description: Return a list of procedures for the current database.
-- Reference: https://msdn.microsoft.com/en-us/library/ms188757.aspx
SELECT ROUTINE_CATALOG AS [DATABASE_NAME],
ROUTINE_SCHEMA AS [SCHEMA_NAME],
ROUTINE_NAME,
ROUTINE_TYPE,
ROUTINE_DEFINITION,
SQL_DATA_ACCESS,
ROUTINE_BODY,
CREATED,
LAST_ALTERED
FROM [INFORMATION_SCHEMA].[ROUTINES]
You can’t perform that action at this time.