Skip to content

Instantly share code, notes, and snippets.

@tun

tun/list_stored_procedures.sql

Last active December 31, 2015 21:49
Show Gist options
  • Save tun/8049338 to your computer and use it in GitHub Desktop.
Save tun/8049338 to your computer and use it in GitHub Desktop.
Download ZIP
List all stored procedures in a MS SQL database
Raw
list_stored_procedures.sql
SELECT ROUTINE_NAME, ROUTINE_DEFINITION, CREATED, LAST_ALTERED
FROM information_schema.routines
WHERE ROUTINE_TYPE = 'PROCEDURE'
ORDER BY ROUTINE_NAME ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment