Home > Management Studio, SQLServer > SQL Server – Management Studio – Changing the default values for Select/Edit commands

SQL Server – Management Studio – Changing the default values for Select/Edit commands


Management Studio provides a shortcut for selecting or editing top rows of a table. You can use this by right-clicking table in Object Explorer, and choosing appropriate option:

image

Select Top 100 Rows: This opens a new query for returning top 1000 rows from the table and executes the same.

Edit Top 200 Rows: Choosing this opens top 200 rows from the table in EDIT mode.

You can change these default values (1000/200)  to required values.

 

Changing Default Values for Select/Edit commands:

These default values can be changed from Management Studio Options:

1. Go to "Tools" Menu > Options,

2. Expand "SQL Server Object Explorer" node > Select "Commands"

3. Change the values as required:

image

4. Click "OK" to apply changes.

 

You should now be able to see modified values for these command in Object Explorer.

image

Hope This Helps!

Vishal

  1. No comments yet.
  1. No trackbacks yet.