Share via

How to enable multiline code editing in Synapse Studio SQL scripts?

Jani Hämäläinen 105 Reputation points
2023-12-20T12:44:10.74+00:00

Hi, I am wondering how to enable multiline code editing in Synapse Studio SQL scripts, like in SSMS by pressing Alt+Shift+Up/Down?

I manage to get it to work sometimes, but on other occasions, it won't work. Currently, I have multiple SQL script tabs open in Synapse Studio, and in one of them, it works just like in SSMS, but in others, it does not work. Is there some setting or etc. to ensure it works always?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,373 questions
Developer technologies Transact-SQL

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator
    2023-12-21T10:06:49.11+00:00

    Hi Jani Hämäläinen ,

    Welcome to Microsoft Q&A platform and thankyou for posting your query here.

    Could you please make sure that the SQL scripts are published before you are trying to use multiline code selection and editing?

    I tried at my end and 'Alt+Shift+Up/Down' is working for both SSMS and SQL Scripts(when it is published).

    Hope it helps. Kindly let us know how it goes. Thankyou

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.