SQL Server Table Properties

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>’

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.