SQL查詢出表、存儲過程、觸發(fā)器的創(chuàng)建時間和最后修改時間示例

--查詢建立時間

--表

select * from sysobjects where id=object_id(N'表名') and xtype='U' 

--表的結(jié)構(gòu) 

select * from syscolumns where id=object_id(N'表名')  

--存儲過程 

select * from sysobjects where id=object_id(N'dqtx') and xtype='P' 

 

--查詢最后修改時間

--存儲過程

select name,modify_date from sys.all_objects where name = '存儲過程' and type='P' order by modify_date desc

--觸發(fā)器

select name,modify_date from sys.all_objects where name = '存儲過程' and type='TR' order by modify_date desc

--表

select * from sys.all_objects where name = '存儲過程' and type='u' order by modify_date desc