Comment of table - how to save/where to find in QVD

[BjoernWollny]

Hello,

in order to have a better overview of our used tables and fields, I started to create comments for each table and each field, by using

comment <TableName> with 'Comment';

comment <FieldName> with 'Comment';

For fields everything works well. I see the comments within the data model editor and also I can find the comment within the XML header of the QVD.

But I cannot find the comment of a table. Did I missed something?

Many thanks in advance and best regards!

[LDR · Accepted solution]

Hi @BjoernWollny 

I was searching for the same question and thanks to your post and after reading QS help I found that the right command is:

Comment Table <TableName> With 'Your comments, descriptions for the table';

Once the table is stored in QVD format then the next step is to get access to our comment:

LOAD
QvBuildNo,
CreatorDoc,
CreateUtcTime,
SourceFileSize,
"TableName",
RecordByteSize,
NoOfRecords,
Offset,
"Length",
"Comment", //In this field we can find our comments.
%Key_QvdTableHeader_B94FCCAC68ED3E20
FROM [lib://YourPath/QVDFileName.qvd](XmlSimple, table is QvdTableHeader);

I can imagine you found the solution however, I thought it could be useful for the rest of this amazing community. 

Regards