开发者

sql 2008 metadata modified date

开发者 https://www.devze.com 2022-12-24 00:08 出处:网络
Is there a way to identify the 开发者_开发问答timestamp when an object(table/view/stored proc...) was modified ?

Is there a way to identify the 开发者_开发问答timestamp when an object(table/view/stored proc...) was modified ?

there's a refdate in sysobjects but it's always the same as crdate atleast in my case and i know that alter view/alter table/alter proc commands have been run many times post creation


modify_date in sys.objects:

Date the object was last modified by using an ALTER statement. If the object is a table or a view, modify_date also changes when a clustered index on the table or view is created or altered.

0

精彩评论

暂无评论...
验证码 换一张
取 消