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
To Select All Data in One or More Tables or Views
- 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.