Overview
From a PhixFlow Datasourcedatasource, you can bring up a list of open a window listing the tables in that database. 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. |
...
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 right-click menuBring up a .
- To display a detailed list of the table attributes, right-click 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.
...
See Also
...