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
Hi @intGod
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_idThis 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