Here is very tiny SQL query which will help you find out when the tables are modified in the SQL server database. First you try the * (get all the columns) and then choose the selected ones.
— List all the tables updated in SQL Server (in desc order)
Use your Database Name
Select * from sys.tables order by Modify_date desc
Like wise, you can also check few more readymade tables which store some helpful information for you.
I hope you will find this helpful. Thanks 🙂