In SSMS when I am in a script, I can hover over a column name and it will give me the column's type and if it is Null/Non Null.
Is there a similar simple way to get which table/query in the From clause a column is referenced from (or the alias), if the developer hasn't included it?
For example the simple query below:
SELECT Column1, table1.column2 From table1 join table2 on table1.id = table2.id
I can see Column2 is referenced from table1, but Column1 doesnt have a reference. If I hover over column1 it might say Column1 (Varchar,Null).
Is there a simple way for SSMS to tell me if column1 is from table1 or table2 like it does its type.