How to change SELECT Top 1000 rows or EDIT Top 200 rows Default Values in SQL Server Management Studio
Issue
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.
Cause
SSMS defaults SELECT to 1000 rows and EDIT to 200 rows by design.
Product Line
PME SQL Databases
Environment
SQL Server Management Studio
Resolution
In order to SELECT or EDIT all tables open SSMS, under Tools, and click Options as shown in the 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 able to SELECT and EDIT all tables as shown below:
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.
Cause
SSMS defaults SELECT to 1000 rows and EDIT to 200 rows by design.
Product Line
PME SQL Databases
Environment
SQL Server Management Studio
Resolution
In order to SELECT or EDIT all tables open SSMS, under Tools, and click Options as shown in the 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 able to SELECT and EDIT all tables as shown below:
게시 대상: 슈나이더 일렉트릭 Korea
도움이 필요하신가요?
제품 선택기
애플리케이션에 적합한 제품과 액세서리를 빠르고 쉽게 찾을 수 있습니다.
견적 받기
영업 관련하여 온라인으로 문의하시면 전문가가 연락드립니다.
구매처
해당 지역의 가장 가까운 슈나이더 일렉트릭 대리점을 쉽게 찾을 수 있습니다.
지원 센터
한 곳에서 모든 요구 사항에 대한 지원 리소스를 찾아보십시오.