Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2009
    Posts
    2

    Unanswered: Add a Table description

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

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    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'

    Jayanta Datta
    DB2 UDB DBA
    IBM India, Global Delivery
    New Delhi

  3. #3
    Join Date
    Jan 2009
    Posts
    2
    Thanks , but i find this command :
    label on table xx01/prova is 'Comment tabella'


    that 's what i was looking for

  4. #4
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    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.

    Jayanta Datta
    DB2 UDB DBA
    IBM India, Global Delivery
    New Delhi

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    The syntax with the '/' is definitively not DB2 (and not SQL). Maybe that's for Oracle or so?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •