Results 1 to 2 of 2

Thread: describe

  1. #1
    Join Date
    Nov 2003

    Unanswered: describe

    hi to all

    pl tell me how to see primary key and all.
    if i type this command describe table tablename

    olumn Type Type
    name schema name Length Scale Nulls

    only above info came.
    but i want to see constrantes on table level.

    pl tell me how to see constrantes.

    thank u

  2. #2
    Join Date
    May 2003
    Try the db2look command. See the Command Reference for details.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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