SSMS Change select top 1000 setting

When you right click a table/view and you get option “Select Top 1000 Rows” and “Edit Top 200 Rows”

select top 1000.PNG

Can you change the default number in the select top and edit top? Instead of 1000 and 200?

Yes you can. By go to ‘Tools” then Choose “Options”

tool options.PNG

In the “Options” window, you can select the last setting “SQL Server Object Explorer” and change the Table and View Options.

options setting.PNG

Click ‘OK’, now your default value for Edit top and Select top <n> Rows changed

after change setting

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at

Up ↑

%d bloggers like this: