Find When was a SQL Server View Last Modified


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

        name as ViewName,
       create_date as CreatedDt,
       modify_date as LastModifiedDt

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.

Leave a Reply

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

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

Facebook photo

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

Connecting to %s

Website Built with

Up ↑

%d bloggers like this: