Steps to modify default SQL Server Management Studio - Select Top 1000 Rows and Edit Top 200 Rows

Do you want to modify the default - Select Top 1000 Rows and Edit Top 200 Rows configuration in SQL Server Management Studio. If yes, read more in this article.


You get two options if we right-click on a SQL Server Management Studio table.

  • Select Top 1000 Rows

  • Edit Top 200 Rows

Select Top 1000 Rows and Edit Top 200 Rows Default Value in SQL Server Management Studio

Can we modify these values? Yes, SSMS configuration can be modified for this requirement.

To modify the properties, navigate to Tools-> Options and Expand SQL Server Object Explorer -> Commands.


You get the default values in the table and view options.


Table and View Options

Let’s modify these values to 100 and click Ok.


Modify the values in SSMS for Select Top and Edit Top rows

The change does not require SSMS restart. Click Ok and right-click on a table, and you can see we get modified values.

  • Select Top 100 Rows

  • Edit Top 100 Rows


View the change



25 views0 comments