sql server 查看对象最后修改时间，根据最后修改时间排序
存储过程
SELECT * FROM sys.all_objects WHERE TYPE=‘P‘ ORDER BY modify_date DESC;
视图
SELECT * FROM sys.all_objects WHERE TYPE=‘v‘ ORDER BY modify_date DESC;
表
SELECT * FROM sys.all_objects WHERE TYPE=‘u‘ ORDER BY modify_date DESC;
原文：http://www.cnblogs.com/cb168/p/7577139.html