Results 1 to 3 of 3

Thread: What is trigger

  1. #1
    Join Date
    Apr 2009

    What is trigger

    can any body explain me the uses of trigger in the database?

  2. #2
    Join Date
    Apr 2009
    To maintain relationship between data.
    When marital status is updated from "Married" to "Unmarried", trigger will delete the spouce and marriage details.
    Trigger are backend validations that minimize front end coding/script
    Last edited by dmasath; 04-17-2009 at 07:43 AM.

  3. #3
    Join Date
    Aug 2005
    The Garden State
    triggers are sql code that gets executed when certain events happen, and either before or after.

    They can be BEFORE or AFTER
    And tied to the operations INSERT, UPDATE, DELETE.

    Many people use triggers +sequences to populate unique auto increment keys, as they're very fast. others use triggers for value validation. others use triggers to perform auditing (ie track when something was created/updated)
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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

Recent Articles