oracle
select a.table_name,count(a.COLUMN_NAME) from all_tab_columns a where a.owner = '表' group by a.TABLE_NAME;
mysql:
SELECT a.`TABLE_NAME`,COUNT(*) FROM COLUMNS a WHERE a.`TABLE_SCHEMA` = '表' GROUP BY a.`TABLE_NAME` ORDER BY a.`TABLE_NAME`
oracle
select a.table_name,count(a.COLUMN_NAME) from all_tab_columns a where a.owner = '表' group by a.TABLE_NAME;
mysql:
SELECT a.`TABLE_NAME`,COUNT(*) FROM COLUMNS a WHERE a.`TABLE_SCHEMA` = '表' GROUP BY a.`TABLE_NAME` ORDER BY a.`TABLE_NAME`
如若转载,请注明出处:https://paper.404sec.com/1432.html