How to change the default value of 1000 in "SELECT TOP 1000" in Azure Data Studio?

user_1526756 0
Viewed 1691

The default value in Azure Data Studio for SELECT TOP 1000 query from the table pop-up menu is 1000. Is there a way to change it?

Searching all over the google shows you how to do that in Visual Studio, but not in Azure Data Studio.

Thank you.

azure-data-studio
2 Answers

It is not possible to change it. I went through the code source and I found out that is hardcoded. You can request it as a feature in GitHub
Maybe the implementation of code snippet can help, but you will have to set N and TableName every time which is not convenient. You can find more details about it here.


In case you want to do it, you can copy-paste this SQL snippet 

{
    "Select top N Rows": {
        "prefix": "sqlSelectTopN",
        "body": "SELECT TOP ${1:N} * FROM ${2:TableName}",
        "description": "Select Top N Rows"
    }
}
user_53948060
user_28423480
Related