Find Table Creation Date In SQL Server


In this article, we will discuss how to get the created date of a table. Sometimes, we may need to know when the table was created in the particular database. Rather than relying on the row inserted date, we can see when the table was created.

Finding the Created date using T-SQL

        name AS TableName,
       create_date AS TableCreatedDate,
       modify_date AS LastModifiedDate

This T-SQL Satement lists all the tables in the current database.

Fig. 1 List all tables with Created Date and Last Modified

Using Table’s Properties

Another way to find the creation date of a table is by,

  • In the Object Explorer in SQL Server Management Studio, go to the database and expand it.
  • Under the Tables folder select the table name.
  • Right click and select Properties from the menu.
  • You will see the created date of the table in the General section under Description
Fig. 2 Finding the Creation Date using Properties


In this simple tips and tricks article, we discussed How to find the creation date of a table in SQL Server. I assume this tip was very useful. We will learn more tips and tricks in upcoming articles, Please share your feedback in the comment section.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Website Built with

Up ↑

%d bloggers like this: