Metadata Tables are used for filling dropdown boxes and source data navigator trees.
Data Source Table Metadata Details
|
Main Settings |
|
|
Get Table Row Counts |
Execute Select count(*) for each table. |
|
Get View Row Counts |
Execute Select count(*) for each view. |
Data Source Field Metadata Details
|
Main Settings |
|
|
Get Primary Key Info |
Import Primary Key Information per table and save into KeyInfo field. |
These types of tables have a pre-specified set of columns.
They are for Source Table Metadata:
MetadataTableName: The Table Name used to fill the source table drop down boxes/tree views.
MetadataTableRowCount: Total number of rows.
MetadataTableType: Table or View.
MetadataDescription: Explanation of the tables purpose/use.
They are for Source Table Field Metadata:
MetadataTableName: The Table Name used to fill the source table drop down boxes/tree views.
MetadataFieldName: The Field Name used to fill the source field drop down boxes/tree views.
MetadataKeyInfo: Primary Key Information.
MetadataDataType: Field Data Type.
MetadataAllowNull: True or False. Nullable if True. Not Nullable if False.
MetadataDescription: Explanation of the fields' purpose/use.
NB!
These tables are created with source SQL expressions based on Data Source Connection Template Settings.
When using customized Connection Templates using multiple databases, schemas or <> prefixed tables (i.e. Microsoft NAV) one must beware the TablePrefix setting.