TSQL 查詢Procedure/Table的建立和修改時間

可以用以下指令查詢:

Procedure

USE AdventureWorks;
GO
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND name = 'uspUpdateEmployeeHireInfo'
GO

Table

USE AdventureWorks;
GO
select  name, create_date, modify_date

from sys.objects
where
type = 'U' and
name = 'Address'

go