sql 查询数据库总条数,各个表总数
mysql查询select table_name,table_rows from information_schema.tables where TABLE_SCHEMA = '数据库名称' order by table_rows desc;sqlServer查询SELECT t0.name,t1.rowsFROM sys.sysobjects t0 JOIN sys.sysindexes t1
·
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
更多推荐
已为社区贡献1条内容
所有评论(0)