Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2012
    Posts
    70

    Unanswered: which index has been created by "create unique constraint"?

    Hello

    how can find the index created by the statement "create unique constraint"?
    I found it with db2look, but I need to find it in the syscat views, and I don't know how.

    Thanks in advance
    Renaud

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You should be able to figure something out between TABCONST, CONSTDEP, and INDEXCOLUSE views.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Syscat.indexes:
    Uniquerule = 'u'
    system_required > 0
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

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