表修改时间

--表修改时间
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