Find Table Creation Date In SQL Server

Introduction

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

SELECT
        name AS TableName,
       create_date AS TableCreatedDate,
       modify_date AS LastModifiedDate
FROM
	sys.tables

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

Conclusion

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:

WordPress.com Logo

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

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s

Website Built with WordPress.com.

Up ↑

%d bloggers like this: