Suppose we want to find the date when the table is created.
We below sql script we will get the created and updated date of the table.
use AdventureWorks2012
SELECT
[name]
as [Table Name],
type_desc as [Table Type],
create_date
as [Created Date],
modify_date
as [Modify Date]
FROM
sys.tables
order by create_date
desc
|
All information is store in sys.table table
See the Output.