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 1

SELECT create_date
FROM sys.tables
WHERE name='YourTableName'

Answer 2

For 2005 up, you can use

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

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

Answer 3

For SQL Server 2005 upwards:

SELECT [name] AS [TableName], [create_date] AS [CreatedDate] FROM sys.tables

For SQL Server 2000 upwards:

SELECT so.[name] AS [TableName], so.[crdate] AS [CreatedDate]
FROM INFORMATION_SCHEMA.TABLES AS it, sysobjects AS so 
WHERE it.[TABLE_NAME] = so.[name]