Skip to content
← Customer Feedback for Redgate

Settings and activity

1 result found

  1. Align ON in JOIN Statements

    25 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  SQL Prompt » Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Kristof commented  · 

    Currently, I can get SQL Prompt to format my SQL like this.

    SELECT
    tbl.name AS TableName,
    col.name AS ColumnName
    FROM
    sys.tables AS tbl
    INNER JOIN
    sys.columns AS col
    ON
    tbl.object_id = col.object_id

    This annoys me because the tables in the FROM statement are not aligned. I would like to be able to achieve something like below where the tables are aligned and the join and ON are indented from the table. So the tables are indented from the FROM and the INNER JOIN is indented from the table. Then, the ON can either be indented from table or aligned to JOIN.

    SELECT
    tbl.name AS TableName,
    col.name AS ColumnName
    FROM
    sys.tables AS tbl
    INNER JOIN
    sys.columns AS col
    ON
    tbl.object_id = col.object_id
    AND @SecondJoinCondition = 1

    Kristof supported this idea  ·