SELECT [name],
[type] AS 类型,
[crdate] AS 创建时间,
[refdate] AS 更新时间
FROM sysobjects
WHERE [name] NOT LIKE 'sp_%' AND [name] NOT LIKE 'sys%'
ORDER BY [refdate] DESC
查询数据库对象的创建时间和更改时间
最新推荐文章于 2023-07-03 12:42:58 发布
SELECT [name],
[type] AS 类型,
[crdate] AS 创建时间,
[refdate] AS 更新时间
FROM sysobjects
WHERE [name] NOT LIKE 'sp_%' AND [name] NOT LIKE 'sys%'
ORDER BY [refdate] DESC