dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: .NET
Expertise: Intermediate
Aug 31, 2017

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


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

ORDER BY ROUTINE_SCHEMA, ROUTINE_NAME
Hannes du Preez
 
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