Friday 28 October 2016

Find the table created date in sql server

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.

Popular Posts