select type, count(type) as ‘count’
from v_SchemaViews
group by type
order by type