Add a Table description

mattxx82 · #1 (**permalink**) 01-27-09, 05:52

Hi , I want to add a description to a table.
There's a way to do it with an sql comand?

JAYANTA_DATTA · #2 (**permalink**) 01-27-09, 06:21

You can have COMMENT added to a Table to put some description:

e.g.

COMMENT ON TABLE EMPLOYEE.TEST_EMPLOYEEID IS 'This table stores dummy employee_id'

mattxx82 · #3 (**permalink**) 01-27-09, 06:27

Thanks , but i find this command :
label on table xx01/prova is 'Comment tabella'

that 's what i was looking for

JAYANTA_DATTA · #4 (**permalink**) 01-27-09, 07:23

is it on DB2 V9.X on LUW? I knew about SECURITY LABEL, but to have description/comment on a table, the above is pretty much new to me.

stolze · #5 (**permalink**) 01-27-09, 14:09

The syntax with the '/' is definitively not DB2 (and not SQL). Maybe that's for Oracle or so?

Internet Services

Web Development

Digital Marketing

Consumer Tech