Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    7

    Unanswered: how to do revsere engineer for foreign key constraint

    Does db2 provide any utility that can generate DDL for foreign key
    from database(reverse enginner for foreign key)?

    If not, can anyone help me a script that will do the work?

    Thanks so much for your help!!!

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Re: how to do revsere engineer for foreign key constraint

    SET INTEGRITY FOR <TABLE> OFF/ON

    This includes the following:
    1. Check constraint checking
    2. Referencial constraint checking
    3. Datalink integrity checking

    or (BUT WARNNING )

    SET INTEGRITY FOR <TABLE> ALL INMEDIATE UNCHECKED

    bay,

Posting Permissions

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