3333
SELECT CREATE_TIME,table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='数据库名' ORDER BY CREATE_TIME DESC
use master
begin
select a.name ,a.crdate,b.rows
from sysobjects as a inner join sysindexes as b on a.id=b.id
where (a.type='U') and (b.indid in(0,1))
order by b.rows desc
end
go