SQL Server table creation date query

Question

How can I get the creation date of the MS SQL table table using SQL query?
I could not see any table physically, but I can query this specific table.

Answer 1

In 2005 you can use

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

I think that in 2000 you should include an audit.

Answer 2

For SQL Server 2005 up:

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

For SQL Server 2000 up:

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

Answer 3

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

Answer 4

For SQL Server 2000:

 SELECT su.name,so.name,so.crdate,* FROM sysobjects so JOIN sysusers su ON so.uid = su.uid WHERE xtype='U' ORDER BY so.name 

Answer 5

If you also need a circuit:

 SELECT CONCAT(ic.TABLE_SCHEMA, '.', st.name) as TableName ,st.create_date ,st.modify_date FROM sys.tables st JOIN INFORMATION_SCHEMA.COLUMNS ic ON ic.TABLE_NAME = st.name GROUP BY ic.TABLE_SCHEMA, st.name, st.create_date, st.modify_date ORDER BY st.create_date