Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    119

    Unanswered: Informational Constraints

    An informational constraints is not enforced in INSERTs and UPDATEs. This means you can insert data which violates your informational constraint. However, it also means you will not see this data in a SELECT. Is there anyway you can see the data without removing constraint.

    Cheers.

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    ... it also means you will not see this data in a SELECT.
    What did you mean by "this data"?
    I thought that I can see any data in a table, if it was not gurded by some security functions.
    Can you show an example?

  3. #3
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    I think he/she wants a report of data which is inconsistent according to the informational contraints. Kind of a "set integrity" in pro-deo mode

    Not possible as far a I know. Not too hard to code in SQL yourself.

Posting Permissions

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