mysql查询

select table_name,table_rows from information_schema.tables where TABLE_SCHEMA = '数据库名称' order by table_rows desc; 

sqlServer查询

SELECT t0.name,t1.rows 
FROM sys.sysobjects t0 JOIN sys.sysindexes t1 ON t0.id = t1.id
WHERE t0.xtype='u'
ORDER BY t1.rows DESC 

Logo

腾讯云面向开发者汇聚海量精品云计算使用和开发经验,营造开放的云计算技术生态圈。

更多推荐