Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Posts
    18

    Unanswered: Regarding dba_constraints,all_constraints,user_constraints

    Hi,

    I need dba_constraints,all_constraints,user_constraints equivalent in db2...

    My requirement is I need to check all the constraints from user level for particular table...

    From Admin side I know the syscat.constname,but cant find out the constraints at user level.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    The DB2 catalog contains all those details. You can query the catalog also by a regular user if that user has the necessary privileges to access the catalog tables/views. If you don't have those privileges, you may be able to address this via static SQL or so.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Oct 2010
    Posts
    18
    Hi,

    can U please tell me what are the privileges needed to access at user level.

    And please post me the query to find the constraints at user level...

    Thanks in advance...

Posting Permissions

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