I needed a T-SQL statement to get the created date of a couple of tables as part of a project. One of my colleagues came up with this query:
SELECT create_date FROM sys.objects WHERE type = ‘U’ AND name = ‘<tablename>’
It works in SQL Server 2005.
The SQL Server 2000 equivalent is:
SELECT crdate FROM sysobjects WHERE xtype = ‘U’ and name = ‘<tablename>’