SQL: Count number of columns in all tables, excluding views

Question

I am creating a query that returns the number of columns in each table, but I want to exclude Views.

The following works but returns View results:

SELECT COUNT(*), table_name
FROM INFORMATION_SCHEMA.COLUMNS
Group By table_name

Any suggestions?

NOTE: MSSQL 2005+

Answer 1

This assumes SQL 2005 or higher

SELECT 
    t.name,
    count(c.name)
FROM 

    sys.tables t 
    inner join sys.columns c
    ON t.object_id = c.object_id


group by t.name

Answer 2

Something like this:

SELECT COUNT(col.column_name), col.table_name
FROM information_schema.columns col
  JOIN information_schema.tables tbl 
       ON tbl.table_name = col.table_name 
          AND tbl.table_schema = col.table_schema
          AND tbl.table_catalog = col.table_catalog
          AND tbl.table_type <> 'VIEW'
GROUP BY col.table_name