How to get column count in SQL?

Question

Can anyone tell me how to get column count in SQL?

Answer 1

Here is the SQL query to count the number of columns in Employee table:

SELECT count (column_name) as Number 

FROM information_schema.columns 

WHERE table_name='Employee' 

Here is the SQL query to get the list of all the columns of Employee table:

SELECT column_name,table_name as Number 

FROM information_schema.columns

WHERE table_name = ‘Employee’

Here is the SQL query to get the list of all the columns of tables in the database:

SELECT column_name,table_name as Number 

FROM information_schema.columns

If you want to learn SQL and writing SQL queries, then check out this SQL Course by Intellipaat that provides Instructor-led training, certification, and also job assistance.