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
![](https://secure.gravatar.com/avatar/6ee1fe6544ac4236840847ed63c3bc2e?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
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