Find When was a SQL Server View Last Modified

Introduction

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.

Conclusion

We will learn more tips and tricks in our upcoming articles, please feel free to share your feedbacks in the comment section.