Scenario: How to check when last time view definition was refreshed or changed
We know that if the data type changes for columns for objects which are used in the view, we have to refresh the view definition by using sp_refreshview to update meta data for columns used in the view.Sometime we need to know what was the last time the view definition was altered or refreshed.
You can use system view to get that information.
Select * from sys.views
Notice that if the view is created and never been altered or definition never been refreshed then created_date=modify_date.
Once you will refresh view definition or alter the view, then modify date will be the date time when the view as altered or definition was refreshed.
Liên hệ Aivivu, đặt vé máy bay tham khảo
ReplyDeletevé máy bay đi Mỹ giá rẻ 2021
lịch bay từ mỹ về việt nam
vé máy bay từ canada về việt nam
vé máy bay từ nhật về việt nam bao nhiêu tiền
Chuyến bay từ Hàn Quốc về Việt Nam
Vé máy bay từ Đài Loan về Việt Nam
các khách sạn cách ly ở hà nội