How to Change Values for Edit Top X and Select Top X Rows in SQL Server Management Studio(SSMS) - SQL Server / TSQL Tutorial Part 20

Scenario:

I am interested to Change Values for Edit Top X and Select Top X Rows in SSMS. How I can do that?

Solution:

If you right click on the Table and see the Rows for Select and Edit, you see Select top 1000 rows and Edit top 200 Rows.

How to Change Top X Number of Rows for Select and Edit Default Setting in SSMS

Go to Tools and then choose Options as shown below.

How to Change Values for Edit Top X and Select Top X Rows Commands

Make changes according to your requirements as shown below. I have changed everything to 10 Rows.

How to Change Values for Edit Top X and Select Top X Rows Commands SSMS Tips and Tricks

Now if you right click on the table, you should see Select top 10 rows and also Edit Top 10 Rows as shown below.

SSMS Tips and Tricks -How to Change Values for Edit Top X and Select Top X Rows