SQL Server和MySql获取当前数据库每个表的列数
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
Empower every person and every organization achieve more in my blog.