Options (SQL Server Object Explorer/Commands)
When you right-click a table or view in Object Explorer, the following two options for displaying rows in the table are presented:
Select Top 1000 Rows
Creates a script in the Query Editor that selects the top 1000 rows.
Edit Top 200 Rows
Opens the table in the Visual Database Tools with 200 rows populated.
Use the General Scripting Options dialog box to change the number of rows that will be opened.