In this post, we will look into some of the useful SQL Queries.
Following SQL Query will be really helpful to find last modified stored procedure or function.
SELECT name, create_date, modify_date
WHERE type = ‘P’ or type = ‘fn’ or type IN (‘FN’, ‘IF’, ‘TF’);
If you want to show last changed item at first use Order By with modified_date desc,
ORDER BY modify_date DESC;