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
SELECT [name], create_date, modify_date FROM sys.tables order by create_date
No comments:
Post a Comment