Find the number of columns in Azure SQL Database

The query returns basic statistics of the numbers of columns in a database.


select [columns], 
    CONVERT(DECIMAL(10,2),1.0*[columns]/[tables]) as average_column_count
from (
    select count(*) [columns],
           count(distinct schema_name(tab.schema_id) + as [tables]
       from sys.tables as tab
            inner join sys.columns as col
                on tab.object_id = col.object_id
) q


  • columns - total number of columns in a database
  • tables - number of tables in a database
  • average_column_count - average number of columns in the tables of a database


  • The query returns just one row

Sample results

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.