Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 How to get updated tables list

Author  Topic 

chinna1214
Starting Member

21 Posts

Posted - 2015-01-22 : 05:26:45
Hi,

Say i have 10 tables in the database and i have added 5 new tables to it. how can i see which tables i have updated recently. And also can i get the date and time that i have updated.

Thanks.

Harish

Ifor
Aged Yak Warrior

700 Posts

Posted - 2015-01-22 : 07:00:32
You may want to look at sys.tables
Go to Top of Page

chinna1214
Starting Member

21 Posts

Posted - 2015-01-22 : 07:12:26
I want to look in all databases and a specific database itself.

Harish
Go to Top of Page
   

- Advertisement -