How to change the ‘Edit Top 200 Rows’ in SQL Management Studio ?

Published on September 14, 2016 by abundantcode

Filed under SQL Server

Last modified September 14, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 687 times

When working with the SQL Server Management Studio and trying to edit the table records , you would have noticed the context menu option "Edit Top 200 Rows".


How do you change this to display all the records for editing instead of "Edit top 200 rows" in the context menu ?

There are couple of ways in which you can do it.

1. Right click on the results of the "Edit top 200 rows" where you will see a context menu with the list of options. Select Pane -> SQL. It would display the query that was run. Modify the query to display all the results.


2. Change the settings in the SQL Server Management studio to display all the rows by following the steps as shown.
– In SQL Management Studio , navigate to Tools –> Options


– Select SQL Server Object Explorer in the left sidebar and change the value for “Edit Top<n> Rows command to 0 and click the OK button.

– Now, you should see all the records option in the context menu.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Comment


You might be Interested in these Posts

How to hide horizontal or vertical scroll bar using VBA Code in Excel ?

Here's a VBA code that hides the horizontal and vertical scroll bar in Microsoft Excel. How to hide...

Deleting all the hidden rows and columns in the active worksheet using VBA

Do you want to delete all the hidden rows and columns in the active worksheet in Microsoft Excel usi...

Displaying all the worksheet names in Excel using VBA Code

Do you want to display the names of the worksheets in the excel workbook ?. Here;s how you can do it...