Format: stack list table view format for JOINs
You already provide an option to align column aliases in a select statement by a table view option in the stack list.
how about alignment for tables aliases in a JOIN statement
e.g.
SELECT *
FROM dbo.table1 t1
JOIN dbo.tablexyz2 tx2 ON (tx2.c1 = t1.c1)
JOIN dbo.table t ON (t.c1 = tx2.c2)
/*****************************
** To This
** using _ to simulate spaces
/*****************************/
SELECT *
FROM
____dbo.table1 _t1
JOIN dbo.tablexyz2 tx2 ON (tx2.c1 = t1.c1)
JOIN dbo.table __t _ON (t.c1 = tx2.c2)
salman mubbashir
shared this idea
-
Carlos Hanson
commented
I also would like to see table joins where the table alias and the keyword ON are stacked like AS in the select clause.
-
salman mubbashir
commented
on the blog site the alignment is not clear.
copy it from the screen and pasting into notepad makes the alignment more clear.
Each of the alias are left aligned in a column... i.e. each t is below the other. Each ON comes below the other ON.