Check created and modified date of all tables in a database

Client had sent a mail stating that, 'I have created a table yesterday in MyDatabase and pick it for the process'. he did not mention the table name :-(. So I needed to check which is the table created with latest date or yesterday's date. I just found the script to accomplish it.

USE MyDatabase

SELECT [name], create_date, modify_date FROM sys.tables order by create_date

No comments:

Post a Comment