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