Browse FAQs

How to change SELECT Top 1000 rows or EDIT Top 200 rows Default Values in SQL Server Management Studio?

Published date: 18 December 2019

Product Line
PME SQL Databases, ApplicationModules, ION_Data, ION_Network, ...

Environment
SQL Server Management Studio, 

Cause
In SSMS when we want to review Tables records, it is only possible to SELECT Top 1000 rows and EDIT Top 200 rows by default, and it is not possible to SELECT or EDIT all Tables in some cases that we need to review all.



Resolution
In order to SELECT or EDIT all tables open SSMS, under Tools, click Options as shown in tha image below:




Then expand SQL Server Object Explorer, and select Command:



Then change those 200 and 1000 values to 0 for both options. This will give you SELECT and EDIT all Tables as shown below:



 Click on OK and then you will be abe to SELECT and EDIT all tables as shown below:




Was this helpful?

What can we do to improve the information ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.