DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: intrvw qstn (only trigger not in constraint)

  1. #1
    Join Date
    Dec 2002

    intrvw qstn (only trigger not in constraint)

    Hi All

    This is 1 of the intrvw question.

    When will it be imperative to handle data integrity only in triggers and cannot be handled by in integrity constraints

    i gave the answer say on certain holidays(sat & sun) i dont want to give users access to the databse tables.

    What are others where we will have to manage data integrity only trhough triggers & cannot be done through integrity constraints


  2. #2
    Join Date
    May 2002
    If you look at constraints checking for data, those check for validity of the data (is this the right type of data?), not whether the data shouldn't be put in.

    If you look at the triggers for checking/enforcing business rules, those check for is it okay to put the data in (is now a good time, is this user allowed to insert/update/delete, are customer numbers allowed to be changed, etc?).
    Last edited by stecal; 10-04-2003 at 02:47 PM.

Posting Permissions

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

Click Here to Expand Forum to Full Width