查询字段超过50的表名SQL
---------查询字段超过50的表名-----------
select table_name as 表名,count(column_name) as 表的总列数 from information_schema.columns N join sys.sysobjects M on N.TABLE_NAME=M.name where M.xtype='U'
group by table_name having count(column_name)>50 order by 表的总列数