Pewrmit override Alias name assignment during Query design when LONG table names prevent viewing of columns/fields in the columns window.
From a SSMS Query window execute a statement like:
CREATE TABLE #tempAllBin (ID Int);
Then, in your query designed, browse to the TempDB and locate the new temp table. It will have a name like: "#tempAllBins________________________________________________________________________________________________________000000090BC2".
Select this table name and drag it into the query designer window in your tool. - The length of the table name makes it impossible to view the column names in the column window, as well as a number of other complcations arising from the length of that table name. I see no way to assign a SHORTER ALIAS Name in your query designer to alleviate this condition. Please permit assginemt of a shorter alias (as SQL rules and T-SQL commonly permit) for use in your query designer tool!
Also: Can you enhance the tool to help us with creating PIVOT queries?
Support Team commented
Thanks for your comment here!
Please, rest assured, the information has been submitted for consideration of the implementation of such a possibility.
If the decision is made in a positive way, you can see the changes here:
Devart Support Team
typo fix: "Then, in your Query Designer Tool, browse to the TempDB..."