When you right click a table/view and you get option “Select Top 1000 Rows” and “Edit Top 200 Rows”
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”
In the “Options” window, you can select the last setting “SQL Server Object Explorer” and change the Table and View Options.
Click ‘OK’, now your default value for Edit top and Select top <n> Rows changed
Leave a Reply