List columns by name length in Azure SQL Database

Rene Castro - Dataedo Team Rene Castro 2018-12-10

Table of Contents:


    This query returns the columns in a database sorted by their name length.

    Query

    select col.name as column_name,
        len(col.name) as column_name_length,
        schema_name(tab.schema_id) as schema_name,
        tab.name as table_name
     from sys.tables as tab
            inner join sys.columns as col 
            on tab.object_id = col.object_id
    order by len(col.name) desc,
        col.name
    

    Columns

    • column_name - name of the column
    • column_name_length - length of the column name
    • schema_name - schema name of the column table
    • table_name - table name of the column

    Rows

    • One row: represents one column of each table in a database
    • Scope of rows: each column that exists in a database
    • Ordered by: length descending - from longest to shortest

    Sample results

    0
    There are no comments. Click here to write the first comment.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy.
    Accept