--查詢建立時(shí)間

--表

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

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

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

--存儲(chǔ)過程 

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

 

--查詢最后修改時(shí)間

--存儲(chǔ)過程

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

--觸發(fā)器

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

--表

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