Q&A for professional and enthusiast programmers
Select 'posts' as [table] , Max(CreationDate) as [Last date] From Posts union select 'votes', max(creationdate) from votes union select 'users', max(creationdate) from users union select 'comments', max(creationdate) from comments union select 'users', max(creationdate) from users union select 'postfeedback', max(creationdate) from postfeedback union select 'posthistory', max(creationdate) from posthistory union select 'postlinks', max(creationdate) from postlinks union select 'reviewtaskResults', max(creationdate) from reviewtaskResults union select 'reviewtasks', max(creationdate) from reviewtasks union select 'suggestededits', max(creationdate) from suggestededits union select 'suggestededitvotes', max(creationdate) from suggestededitvotes union select 'tagsynonyms', max(creationdate) from tagsynonyms order by 2 desc