PhixFlow Help

table

Forms: Table

A Table is a reference to an external database table object.

Form: Table Details List

There are two forms of the Table list:

  • Detailed list - Shows the table name plus other (database specific) details
  • Simple list - Just shows the table names

In both cases the lists show all the tables for the parent Datasource that the user defined in the Datasource Instance has permission to view.

The list below gives the column headers returned for an Oracle database.

Field Description
OWNER The Schema Owner
TABLENAME The name of the table.
TABLESPACE The Oracle tablespace configured for the table.
NUMROWS Approximate number of rows in this table. Note that this information is based on stats data collected by Oracle and may or may not be up to date.

Table Actions

The following actions are possible from a Table list:

  • Double clicking on a Table entry pops up a Data Grid showing the first page of data returned from the table.
  • Dragging a table and dropping it on a modelling pane creates a Database Collector which is linked to the original Datasource. The Collector will be set up to fetch all the table fields and all the table data.
  • From the right-click context menu you can choose to view the table attributes (a simple or detailed list). See Table Attributes.

See Also

Please let us know if we could improve this page feedback@phixflow.com