Alias CTE like tables
When referencing a CTE, the CTE name is also its alias instead of the shortened version. E.g. the CTE NewUsers doesn't get aliased as "nu". Also, when typing "SELECT * FROM NewUsers", navigating to the "*" and hitting tab to expand columns, the expanded column names aren't prefixed with an alias or table name. This could just be a settings issue
0
votes
par20pinspot
shared this idea
-
AdminDevart (_, Devart) commented
Hi,
Thanks for your patience!
Pleae note that if we use a CTE, there is a column suggestion for the CTE when it is used later in the SELECT statement.
Best,
Devart Support Team