Get Last Modified Date of a Table

I tried to get the last-modified date for a table through the available columns of Microsoft SQL Server Management Studio but was shocked to find it was not available. Luckily I found this query on the web which will give you just that.

SELECT name, modify_date FROM sys.tables

Leave a Reply

Your email address will not be published. Required fields are marked *