Get SQL Objects Created Date on Modified Date

SQL objects created date or 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