Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Get Stored Procedure Content and Details

This query can be used to get details regarding stored procedure content.


advertisement

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_DEFINITION
FROM lms_db.INFORMATION_SCHEMA.ROUTINES 
WHERE routine_type = 'PROCEDURE'

ORDER BY ROUTINE_SCHEMA, ROUTINE_NAME


   
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date