Find Table create history

There are some times when you need to find when a SQL server table has been created or modified.

The following query will give you that information.

SELECT name, create_date, modify_date

FROM sys.objects

WHERE type = 'U'

order by create_date desc

you will find the result as