Skip to content

Instantly share code, notes, and snippets.

@alandalegend

alandalegend/allProcedures.sql

Created June 29, 2023 04:18
Show Gist options
  • Save alandalegend/cdf737549d27edb0b3d3961d7d887c09 to your computer and use it in GitHub Desktop.
Save alandalegend/cdf737549d27edb0b3d3961d7d887c09 to your computer and use it in GitHub Desktop.
Download ZIP
Obtener todos los storedProcedures de tu bd
Raw
allProcedures.sql
/*Fuente: https://database.guide/3-ways-to-list-all-stored-procedures-in-a-sql-server-database/*/
SELECT
ROUTINE_SCHEMA,
ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment