devxlogo

Get Stored Procedure Content and Details

Get Stored Procedure Content and Details

The following query can be used to get details such as when the Stored Procedure was last updated???as well as its content.

SELECT 	CREATED,	LAST_ALTERED,	SPECIFIC_NAME, 	ROUTINE_SCHEMA,	ROUTINE_NAME,	ROUTINE_DEFINITIONFROM lms_db.INFORMATION_SCHEMA.ROUTINES WHERE routine_type = 'PROCEDURE'ORDER BY ROUTINE_SCHEMA, ROUTINE_NAME

devx-admin

Share the Post: