Creating a table using CDS (HDBDD)

[former_member1362068]

Hi,

I am trying to create a table using CDS syntax, but facing a challenge to add column comments.(Comments that are part of table in systems view and not part of cds definition in project explorer)

Could you please help me with the syntax to add comments

Example : I want to see the comment "Original Name" when we open the table definition from the systems tab of developer perspective.

entity ZEMP_CDS1 {

firstname : String(20) not null /*Original Name*/;

lastname : String(20) default 'doe'; //LAST NAME

age : Integer not null;

salary : Decimal(7,2) not null;

};

Regards

Vishwatej

[lucas_oliveira · Accepted solution]

Hi Vishwatej,

Could not find anything concrete in the documentation. However, that does not seem to be available. Check what the doc says:

Migrate an Entity from hdbtable to CDS (hdbdd) - SAP HANA Developer Guide for SAP HANA Studio - SAP ...

Note
In 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.

Regards,

Lucas de Oliveira