Select * From

Go Up to Available object actions by DBMS

This action lets you retrieve all data contained in tables or views. Results are displayed in a row and column grid.

Platform Availability

• DB2 LUW
• DB2 z/OS
• MySQL
• ORCL
• SQL SVR
• SYB ASE

To Select All Data in One or More Tables or Views

1. Initiate a Select * From action against one or more tables or views. For more information see Initiating an object operation.

For each selected table or view, a two-tabbed window opens:

• The Results tab displays the data selected from the table, in a grid similar to a spreadsheet. Right-click and toolbar options offer many of the functions provided in the Results editor. For more information, see Using the Results Editor.
• The Query tab displays the full query generated for the operation. Right-click and toolbar options offer many of the functions provided in the ISQL editor. For more information, see Using the SQL Editor.