Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 From a PhixFlow Datasource, you can bring up a list of the tables in that database. The list show all the tables for the parent Datasource that the user users defined in the Datasource Instance has permission to view. The list below gives the column headers returned for an Oracle database. datasource instances have permission to view.

For each table, you can bring up:

  • the data in the table
  • a list of the attributes defined in that table

Depending on where you call up the table list from, it will be either a simple list with only the name of each table, or a detailed list.

Detailed table list

In the detailed table list, the following fields are shown for each table:

FieldDescription
OWNER
OwnerThe
Schema Owner
table owner
TABLENAME
NameThe name of the table
.
TABLESPACE
Tablespace Name
The Oracle tablespace configured for the table. NUMROWS
That tablespace this table is contained in
RowsApproximate number of rows in this table. Note that this information is based on stats
data
collected by
Oracle and may or may
the database, and in some cases may not be fully up-to-date.

Table

...

The following actions are possible from a Table list:

...

actions

You can do the following things from the table list:

  • Show data in table - double-click on the table
  • Bring up a simple list of the table attributes - select Show Table Attributes from the right-click menu
  • Bring up a detailed list of the table attributes - select Show Attribute Details from the right-click menu
  • Create a collector for the stream - drag the table onto a model view, or select Create a Collector from the right-click menu

Table Attributes

Depending on how you call them up, database table attributes can be shown in a simple list, with only the name of each attribute, or a detailed list.

Anchor
databaseTableAttributesDetailedList
databaseTableAttributesDetailedList
Detailed table attributes list

In the detailed table attributes list, the following fields are shown for each attribute:

FieldDescription
TABLENAMEThe name of the table.
COLUMNIDThe internal id for the column.
COLUMNNAMEThe name of the attribute
DATATYPEThe data type.
CHARLENGTHFor character types, the column length in characters (not necessarily the same as the length in bytes depending on character sets).
DATAPRECISIONFor numeric types, the data precision.
DATASCALEFor numeric types, the data scale.
NULLABLEWhether or not the column allows null values.
DEFAULTLENGTHThe default length of the column.

Table attribute actions

The following actions are possible from a table attribute list:

  • You can select several attributes and drag them onto a modelling pane, to create a database collector to read the selected fields from that table.

See Also