查詢最後更新的數據庫對象.

SELECT * FROM sys.all_objects
WHERE 1=1
--AND TYPE IN ('p','pc')
AND is_ms_shipped=0
AND TYPE IN ('FN','P','U','V','TR')
AND left([name],3)!='sp_'
ORDER BY modify_date DESC
posted @ 2008-12-30 23:44  Benny Ng  阅读(166)  评论(0编辑  收藏  举报