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?
Anonymous
shared this idea
-
Support Team
commented
Hi,
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:
https://www.devart.com/dbforge/sql/querybuilder/revision_history.html"Best,
Devart Support Team -
Anonymous
commented
typo fix: "Then, in your Query Designer Tool, browse to the TempDB..."