Tuesday, March 13, 2018

SQL Server table creation date query

This query will tell you when this table is created.


SELECT [name]        AS [TableName], [create_date] AS [CreatedDate] 
FROM   sys.tables 
WHERE  NAME = 'user' -- table name

No comments:

Post a Comment