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

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.

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

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

Buy me a Coffee If I helped you.