Properly format the start of a CTAS in Azure Synapse Analytics
SQL Prompt does not start a new line for the SELECT portion of a CTAS statement within Azure Synapse Analytics when there is a defined distribution or index using a WITH clause. Instead the SELECT statement is tabbed way over to the right.
6
votes
![](https://secure.gravatar.com/avatar/c4a1d00b220896fc47fcb2e11ba38533?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
David Smith commented
Yes, please! I've been frustrated with this since returning to redgate. Seems like a simple implementation, almost more of a bug than a feature request.