Quick Data Viewer

Top  Previous  Next

LA allows you to right click on any table or view and quickly view the data it may contain.

NOTE: this same data viewer is also embedded in the table and view editors.

 

 

You may return the top, bottom or all.

If you select top or bottom you will be prompted for how many rows to return.

 

 

Enter a new number or use the spin control to adjust the current number up or down.

 

The data will then be returned.

If your table has a estimated row count of greater than 300,000 then the limit will be set to 1000 to

limit the amount of data transferred to the client.  A 300,000 row record set eats a lot of local memory.

You can use the combination of the limit and offset to page through the large result set.

You may also filter the returned result set by click the filter button on the DB Navigator.