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

Question

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.

Catkin

Answer 1

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"
    }
}

Leastwise

Answer 2

You can use the Select Top N extension for this.

Christadelphian