...
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. |
...
- 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 a detailed list of the table attributes - select Show Attribute Details from the right-click menu
- Create a collector for the stream - HELPDEVTODO: drag doesn't currently work drag the table onto a model view, or select Create a Collector from the right-click menu
...
Table Attributes
Table Attributes are the columns of an external TableDepending 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 | ||||
|---|---|---|---|---|
|
...
Detailed table attributes
...
list
...
- Detailed list - Shows the attribute name plus other (database specific) details
- Simple list - Just shows the attribute names
In both cases the lists show all the attributes for the selected Table.The list below gives the column headers returned for an Oracle database. See Oracle documentation for more details.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 table attribute list:
- Selecting You can select several attributes and dragging drag them onto a modelling pane creates a Database Collector which is linked to the original Datasource. The Collector will be set up to fetch just the selected columns and all the table data, to create a database collector to read the selected fields from that table.