Skip to content

Mr SQL's Blog

Musings on Microsoft SQL Server

It is possible to obtain the ‘date of creation’ of a table, as well as its last modification date (DDL, not DML) by running the following query:-

SELECT [name] AS 'Table', 
[create_date] AS 'Creation Date', 
[modify_date] AS 'Modification Date' 
FROM sys.objects
WHERE type_desc = 'USER_TABLE' 
ORDER BY [modify_date] DESC
Advertisements

Tags: , , , ,

%d bloggers like this: