Published on: 26 Jan, 2021

How to find the last modified table in TSQL?

Tumblr Digg Google Plus

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

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.