T-SQL: Creation date/time of tables

Bschelst/ February 11, 2019/ SQL-Server/ 0 comments

When you are looking for the creation date/time of certain tables, you can easily find that in the sys.tables.
You can use the code below in order to list all tables, and the creation date of those tables.

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

Leave a Comment

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