SQL Server table creation date query

Question

How can I get the table creation date of a MS SQL table using a SQL query?
I could not see any table physically but I can query that particular table.

Answer

For 2005 up, you can use

SELECT
        [name]
       ,create_date
       ,modify_date
FROM
        sys.tables

​x
 
SELECT        [name]       ,create_date       ,modify_dateFROM        sys.tables​

I think for 2000, you need to have enabled auditing.

Accepted Answer

For 2005 up, you can use SELECT        [name]       ,create_date       ,modify_dateFROM        sys.tablesI think for 2000, you need to have enabled auditing.

Advertisement

Answer