When my SQL table was updated???

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 🙂

Rate this post

One Comment

Leave a Reply