Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2014
    Posts
    294

    Unanswered: Catalog table Enforced status

    Hi,

    I have altered the foreign key constraint on a table to be not enforced.
    can some one tell me the query to find out whether the constraint is enforced or not ?
    In which catalog table I can find the status of that particular enforced column .

  2. #2
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    Study the docs : join syscat.tables and syscat.tabconst (the type column and the enforced column)

  3. #3
    Join Date
    Jul 2014
    Posts
    294
    Thanks I got the column from syscat.tabconst catalog table .

Tags for this Thread

Posting Permissions

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