Consultant Diary:
SQL Server - In order to get the list of tables in a database with column counts, run the below query in SQL Server Management Studio.
SELECT table_name
, COUNT(COLUMN_NAME) RecCount
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = ‘DBname’ AND TABLE_SCHEMA = ‘dbo’ and TABLE_NAME like ‘Tablename%’
group by TABLE_NAME
order by RecCount