SQL Query to find total number of columns in a Table in SQL Database,

SELECT COUNT(*)
  FROM INFORMATION_SCHEMA.COLUMNS
 WHERE table_catalog = 'DatabaseName' -- the database
   AND table_name = 'TableName'