If you need to find out which tables have been recently modified. You can check this by querying the sys.tables in TSQL based on the modify_date column. 

Here is the TSQL query to select the last modified table based on the recent date in SQL Server.

SELECT * 
FROM sys.tables
ORDER BY modify_date DESC