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';

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?