Ever wondered to see all the tables names and the last time they were updated?

This is a query which will give you all the desired result.

Select
Distinct Object_name(object_id) as DatabaseName,
Object_id,
Database_id,
Last_user_update
From
Sys.dm_db_index_usage_stats
Where
database_id = db_id() and last_user_update is not null