Comment table
Provides a way of displaying the table comments (metadata) from databases or spreadsheets.
Table names not present in the app are ignored. If multiple occurrences of a table name are found, the last value is used. The keyword can be used to read comments from a data source.
Syntax:
comment [tables] tablelist using mapname
comment [table] tablename with comment
Arguments:
Argument | Description |
---|---|
tablelist | (table{,table}) |
mapname | The name of a mapping table previously read in a mapping LOAD or mapping SELECT statement. |
tablename | The name of the table that should be commented. |
comment | The comment that should be added to the table. |
Example 1:
Commentmap:
mapping LOAD * inline [
a,b
Main,This is the fact table
Currencies, Currency helper table
];
comment tables using Commentmap;
Example 2:
comment table Main with 'Main fact table';