如何在数据库中查询最新更新的表？

[evcent]

在SQL SERVICE 2005中查询

如何在数据库中查询最新更新的表？

[rucypli]

slect *
from sysobjects
order by crtdate desc

[jia_guijun]

select * from sys.tables order by modify_date desc

[fwacky]

select top 10  * from sys.tables where type = 'u' order by modify_date desc

select top 10 * from sysobjects where xtype = 'u' order by crdate desc	


都行！