Query to Count number of Columns in database Table in SQL Server

Hi KatieNgoc,

Refer the below query.

Database

For this query I have used of Northwind database that you can download using the link given below.

Download Northwind Database

SQL

SELECT COUNT(*) ColumnCount
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = 'Northwind' -- Database Name
AND TABLE_SCHEMA = 'dbo' -- Schema Name
AND TABLE_NAME = 'Customers' -- Table Name

Output

11