Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006
    Posts
    17

    Unanswered: how to print table definitions?

    Hi,

    I m using db2 8.02 and i would like to know how to print a table definition?

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    describe table tabname
    or u need DDL??
    db2look for that
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    All that (db2look and describe) is based on the DB2 catalog views, e.g. SYSCAT.TABLES, SYSCAT.COLUMN, SYSCAT.DATATYPES, SYSCAT.TABCONTS etc. You can also use those views yourself to retrieve the information you want.
    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
  •