Sql server:(连接数据库后,点击当前数据库再新建查询)
select count(c.name),o.name from syscolumns c left join sysobjects o on c.id=o.id group by o.name
MySql:
select count(t.table_name),c.table_name from information_schema.columns c left join INFORMATION_SCHEMA.TABLES t on c.table_name=t.table_name where t.table_schema='数据库名字' group by t.table_name