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:
HELPDEVTODO: confirm this in the new gui
| Field | Description |
|---|---|
| OWNEROwner | The table owner |
| TABLENAMEName | The name of the table |
| TABLESPACENAMETablespace Name | That tablespace this table is contained in |
| NUMROWSRows | 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 right-click menuBring up a .
- To display a detailed list of the table attributes, right-click and select Show Attribute Details; see Table Attribute Details from the right-click menuCreate 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 - HELPDEVTODO: drag doesn't currently work drag ,
- 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:
HELPDEVTODO: this currently not working in new gui
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
...