Counting Number of Columns in a Table

select count(*)
from Information_Schema.Columns c
where table_name = 'mytable'


stackoverflow