Note: By setting the Preview row limit in the DB Navigator preferences, you can adjust the number of rows displayed in the Preview tab.
2. To view all data in a table:
a. Select a table name in the DB Structure view.
b. Right-click on the table and choose Generate Select in SQL Editor to open a SQL editor containing the generated SELECT statement.
c. Click Execute SQL to open a SQL Results view containing a browse with the first batch of records. To retrieve the next batch of records, click Retrieve more rows; to get all the records, click Retrieve All Rows. You can add a WHERE clause to the SQL SELECT statements to further refine the data retrieved. You can also modify the text and remove any columns.
to open a SQL Results view containing a browse with the first batch of records. To retrieve the next batch of records, click Retrieve more rows; to get all the records, click Retrieve All Rows. You can add a WHERE clause to the SQL SELECT statements to further refine the data retrieved. You can also modify the text and remove any columns.