--表修改时间
SELECT name,crdate,refdate FROM SYSOBJECTS WHERE XTYPE='U' order by refdate desc
select name,create_date,modify_date from sys.tables ORDER BY modify_date DESC
--存储过程修改时间
select name,create_date,modify_date from sys.procedures ORDER BY modify_date DESC
转载于:https://www.cnblogs.com/yufeng219/p/6247873.html