4

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.

Dark Templar
  • 1,175
  • 13
  • 27

2 Answers2

4

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"
    }
}
Mohamed Sahbi
  • 1,065
  • 10
  • 24
1

You can use the Select Top N extension for this.

adrien
  • 504
  • 1
  • 7
  • 17