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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Website Built with WordPress.com.

Up ↑

%d bloggers like this: