How can we mention Column comments during TABLE creation using hdbcds file

[Former Member]

I could not find the syntax to mention column comments.

In the below mentioned blog they have mentioned, there is no way to create column comments. Is this true?

https://help.sap.com/viewer/09b6623836854766b682356393c6c416/2.0.02/en-US/f1bd74e968cd4fa3afa16fa00d...

CDS, there is no way to reproduce the column-comments defined in an hdbtable artifact. You can use source code comments, for example, '/* */' or '//', however, the comments do not appear in the catalog table after activation of the new CDS artifact.

[pfefferf]

Comments in CDS files can be created since HANA 2.0 SPS02 (check the blog here or the official help for more details and examples).

Regards,
Florian

[Former Member]

Even after mentioning the @Comment field in HDBCDS file, I am not able to see the column comments. I have added this and checking the TABLE_COLUMNS to validate the same but its null always.

The HANA version details we are using:

SAP HANA Version 2.00.023.00.1513691289 (fa/hana2sp02) Platform: Cloud Foundry Any suggestions why I am not able to add column comments while creating the table through HDBCDS.

[pfefferf]

Can you show how you have added them and that the HDI container is really based on 2.0 SPS02?

[Former Member]

Find the sample hdbcds file as an attachment and version details.

hanainfo.png

samplefile.txt