The following query will list all tables within a database with a count of the columns within that table, sorted by column count desc.
SELECT TABLE_NAME, COUNT(*) ColumnCount
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_catalog = 'YOUR_DATABASE_NAME'
GROUP BY TABLE_NAME
ORDER BY ColumnCount DESC