lAST USED TABLE

SELECT 

    OBJECT_NAME(i.object_id) AS TableName,

    i.last_user_seek,

    i.last_user_scan,

    i.last_user_lookup,

    i.last_user_update

FROM 

    sys.dm_db_index_usage_stats i

JOIN 

    sys.objects o ON i.object_id = o.object_id

WHERE 

    o.type = 'U' -- User tables

    AND i.database_id = DB_ID()

ORDER BY 

    GREATEST(ISNULL(i.last_user_seek, '1900-01-01'),

             ISNULL(i.last_user_scan, '1900-01-01'),

             ISNULL(i.last_user_lookup, '1900-01-01'),

             ISNULL(i.last_user_update, '1900-01-01')) ASC;