Skip to Content
avatar image
Former Member

How to add comments to table definition of column using HDBDD?

I could able to create tables using HDBDD syntax. But I want to add some comment to each column for the table. So that while opening table definition from catalog, the same comment should be present.

For example

Table Name Employee

Column Name     type                                        Comment

firstname              VARCHAR                              First Name of employee

lastname               VARCHAR                              Last name of employee

age                         INTEGER                              Age of employee in Months

If we define in HDBDD, it will be like

@Schema: 'MySchema'

@Catalog.table.Type: #COLUMN

entity Employee {

     firstname :  String(20);

     lastname     : String(20);

     age               : Integer;

};

In above hdbdd code, where can I put comment so that the comment should be visible  in table definition. I don't know, whether it is feasible thru hdbdd.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 23, 2016 at 04:57 PM

    Hi Rajib,

    Adding comments during table creation is not possible. You can add your comments to the fields after the table is created with using,

    COMMENT ON COLUMN "schema"."table".field1 IS 'comments for field1';

    Benedict

    Add comment
    10|10000 characters needed characters exceeded