查询数据库对象的创建时间和更改时间

SELECT [name],
  [type] AS 类型,
  [crdate] AS 创建时间,
  [refdate] AS 更新时间
FROM sysobjects
WHERE [name] NOT LIKE 'sp_%' AND [name] NOT LIKE 'sys%'
ORDER BY [refdate] DESC