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
Arguments:
| Argument | Description |
|---|---|
| tablelist | (table{,table}) |
| mapname | The name of a mapping table previously read in a mapping LOAD or mapping SELECT statement. |
Syntax:
To set individual comments, the following syntax is used:
comment [table] tablename with comment
Arguments:
| Argument | Description |
|---|---|
| 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’;
Learn more
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!