Skip to main content

Table Menu

The Table menu is accessed from the Query Canvas panel, and allows users to access and process various functions associated with the selected table.

  1. In the Query Canvas, right-click the header section of the desired table. The Table menu appears. The options available in this menu vary based on the query connection type.

  2. See the following table for more information about the available options in the Table menu.

    3. Menu Item

    Description

    Refresh Fields

    Updates the table fields.

    Set Alias

    For all connection queries excluding SAP, opens the Table Alias panel, allowing the user to enter an alias name for the table.

    Note:
    • Alias can be a name or a number.
    • By default, the alias name is assigned the first three letters of the table name.

    Change Database/Library
    • For iSeries and SQL Server connection queries, opens the Select Library panel, allowing the user to select a different database or library, from which to retrieve the table data. The newly selected database or library name appears in the table header section.
    • See Use a Parameter to Supply a Database or Library Name for more information about using a parameter for assigning the database or library, to be used when executing the query.

    Change Owner

    For SQL Server connection queries, opens the Change Table Owner panel, allowing the user to specify a different table owner.

    Change Schema

    For Oracle connection queries, opens the Change Schema panel, allowing the user to specify a different table schema.

    Remove Multiple Tables

    Allows the user to remove multiple tables, and any associated relationships and selected fields from the query.

    Remove Table

    Removes the current table, and any associated relationships and selected fields from the query.

Was this article helpful?

We're sorry to hear that.

Powered by Zendesk