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.
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
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