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.

dbo.sysdiagrams
sys.tables
sys.all_columns
sys.objects
sys.foreign_key_columns
sys.data_spaces

I hope you will find this helpful. Thanks 🙂