SQL查询表、视图、存储过程、函数的创建和变更时间
SQL查询表、视图、存储过程、函数的创建和变更时间
SELECT[name],
case[type]when\'U\'then\'TB\'when\'V\'then\'VE\'when\'P\'then\'SP\'when\'IF\'then\'FC\'endas型,
[crdate]as作成時間,
[refdate]as更新時間
FROMsysobjects
Where([type]=\'U\'or[type]=\'V\'OR[type]=\'P\'or[type]=\'IF\'...[查看详细内容]
SELECT[name],
case[type]when\'U\'then\'TB\'when\'V\'then\'VE\'when\'P\'then\'SP\'when\'IF\'then\'FC\'endas型,
[crdate]as作成時間,
[refdate]as更新時間
FROMsysobjects
Where([type]=\'U\'or[type]=\'V\'OR[type]=\'P\'or[type]=\'IF\'...[查看详细内容]
tags： SQL查询表
