Opening Data Editor

There are two ways to open the Data Editor.

Using the Object Explorer:

1. Choose the database table, view or synonym, which you want to edit and select Data - > <Option> menu.

2. There are three options to retrieve table data: Return All Rows, Return Top Rows and Query.
   The Return All Rows option attempts to asyncroniosly retrieve all data from the table in the grid. You can interrupt  the retrieval process at any time using Cancel toolbar button or Data -> Cancel top-level menu.
   The Return Top Rows option attempts to retrieve specified number of the table rows. You will be to retrieve the rest of rows later on.
   The Query option allows to specify SQL SELECT statement to retrieve the data for the selected database object.
   
   

Using the top-level Tools menu:

1. Use top-level Tools -> Data Editor menu
2. Select the required server connection and the database in the Connect dialog box.
3. Select the required table, view or synonym in the Select Object dialog box. You can type the object name or use Object List button for the lookup.
4. Select the number of top rows you want to retrieve initially. You can re-retrieve rows or specify a SELECT SQL query later on.