I have a before and after query which I'm currently looking at this is filled with Ambiguous Column Name Errors.
I'd like to be able to hover over certain columns in the query in the before query and see which table this was mapped to. When hovering at the moment, all I see is
column k(datatype, null)
Is there a way to achieve this on SQL Server Management 2012? I'd be happy with a third party plug in if there possible to be installed.
As an example,
SELECT * FROM TABLE1 WHERE column1 = "stack"
In the above example, I'd want to hover over "column1" and see it reference to "Table1" somehow.