In this simple tips and tricks article, I would like to share how to when was a view last modified. Let’s have a look at the below T-SQL Statement
SELECT name as ViewName, create_date as CreatedDt, modify_date as LastModifiedDt FROM sys.views
In the above T-SQL Statement list, from the column LastModifiedDt column we can find when was the view last modified.
We will learn more tips and tricks in our upcoming articles, please feel free to share your feedbacks in the comment section.