Viewing Table Data in the Execute SQL Window

Execute a SELECT * FROM query and display contents of the table, global temporary table or proxy table in the query results pane of the Execute SQL window.

Prerequisites
Database Version Table Privileges
SAP Sybase IQ 15.3 and 15.4
Requires one of the following to enable menu option:
  • DBA authority.
  • SELECT permission on the table.
  • You own the table.
Queries execute with user's current permissions.
SAP Sybase IQ 16.0
Requires one of the following to enable menu option:
  • SELECT ANY TABLE system privilege.
  • SELECT permission on the table.
  • You own the table.
Queries execute with user's current privileges.
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the Administration Console, expand IQ Servers > Schema Objects > Tables.
  3. Select Tables, Global Temporary Tables, or Proxy Tables.
  4. In the right pane, select a table.
  5. Click the drop-down arrow that appears next to the table name and select View Data in SQL .
    A SELECT * FROM <table> query executes.
  6. (Optional) Modify the SQL statement and click Execute to display different data in the table.
  7. Click Close to close the Execute SQL view.
Parent topic: Tables
Related concepts
Table Columns
Table Permissions
Table Constraints
Table Indexes
Table Triggers
Table Partitions
Related tasks
Creating a Table
Creating a Global Temporary Table
Creating a Proxy Table
Deleting a Table
Generating Table DDL Commands
Moving a Table to Another Dbspace
Validating a System Store Table
Setting the Primary Key
Setting a Clustered Index
Merging Table Data from RLV Store with IQ Main Store
Calculating the Number of Rows in a Table
Moving Table Objects to Another Dbspace
Enabling or Disabling Row-Level Versioning in a Table
Viewing or Modifying Base Table Properties
Viewing or Modifying Global Temporary Table Properties
Viewing and Modifying Proxy Table Properties
Authenticating a Login Account for a Managed Resource
Related reference
Table Privilege Summary