Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    54

    Talking Unanswered: How to drop primary key dynamically..

    Hi!!
    I have this necessity because I don't know constraint name and I must do this in some schemas..

    Have you idea about this?
    What language can I use? Stored procedure or SQL dialect?
    In Oracle I do this with plsql (catalog query+statement)..


    Thank you!
    Fabio

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Use SQL. Look in the catalog views syscat.tabconst:

    http://publib.boulder.ibm.com/infoce...n/r0001062.htm

    Andy

Posting Permissions

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