dcsimg
www.webdeveloper.com
Results 1 to 3 of 3

Thread: What is trigger

  1. #1
    Join Date
    Apr 2009
    Posts
    1

    What is trigger

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

  2. #2
    Join Date
    Apr 2009
    Location
    India
    Posts
    15
    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 08:43 AM.

  3. #3
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    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)

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