Query for finding number of columns in a table?

[Mushtaque Nizamani]

Hi, Is there any query through which i can get the number of columns in a table.

Best Regards, Mushq Mushtaque Ahmed Nizamani Software Engineer Ultimus Pakistan "English is my second language, so please don't mind if i do some grammatical or spelling mistakes in my messages."

[RepliCrux]

SELECT Count(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_Name = 'TableName'