Get SQL Objects Created Date on Modified Date

If we need to know when the SQL objects is modified then we can use the below query to find the objects details.

SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'-- give the type as required