Overview
From a PhixFlow Datasourcedatasource, you can bring up a list of open a window listing the tables in that database. The list show all the tables for the Datasource that the users For example, in the datasource properties tab, in the toolbar click on
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
- the data in the table
- a list of the attributes defined in that table
Depending on where you call up open the table list from, it will be either a simple list with only the name of each table, or a detailed list.
...
The database tables list has a toolbar with common buttons. You can export data from a detailed list using the
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
See also Datasource.
Detailed Table List
In the detailed table list, the following fields are shown for each table:
Field | Description |
---|---|
Owner | The table owner |
Name | The name of the table |
Tablespace Name | That tablespace this table is contained in |
Rows | Approximate number of rows in this table. Note that this information is based on stats collected by the database, and in some cases may not be fully up-to-date. |
Table actions
You can do the following things from the table list:
- Show To show data in table - , double-click on the table.
- Bring up To display a simple list of the table attributes, right-click to display the context menu and select Show Table Attributes from the .
- To display a detailed list of attributes, right-click menuBring up a databaseTableAttributesDetailedList - and select Show Attribute Details from the right-click menuCreate ; see Table Attribute Details below.
- To export data from a table, use the
button; see Download CSV or Excel Data.Insert excerpt _excel_export _excel_export nopanel true - To create a collector for the stream - ,
- either drag the table onto a model view
- or right-click and select Create a Collector
...
- .
Table Attribute Details
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
Depending on how you call display them up, database table attributes can may be shown
- either in a simple list, with only the name of each attribute
...
- or
...
- in detailed list.
...
In the detailed table attributes list, the following fields are shown for each attribute:
Field | Description |
---|---|
TABLENAME | The name of the table. |
COLUMNID | The internal id for the column. |
COLUMNNAME | The name of the attribute |
DATATYPE | The data type. |
CHARLENGTH | For character types, the column length in characters (not necessarily the same as the length in bytes depending on character sets). |
DATAPRECISION | For numeric types, the data precision. |
DATASCALE | For numeric types, the data scale. |
NULLABLE | Whether or not the column allows null values. |
DEFAULTLENGTH | The 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
...
model window. PhixFlow creates a database collector to read the selected fields from that table.