How to find the number of feilds in a table

select COUNT(*) as ColumnCount from information_schema.columns
where table_name = 'table_name'