IT Community - Software Programming, Web Development and Technical Support

diffrence between and constraints and triggers

This is a discussion on diffrence between and constraints and triggers within the Database Support forums, part of the Web Development category; what is the diffrence between and constraints and triggers?...


Go Back   IT Community - Software Programming, Web Development and Technical Support > Web Development > Database Support

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 07-12-2007, 02:36 AM
sivakumar sivakumar is offline
D-Web Trainee
 
Join Date: Jul 2007
Posts: 36
sivakumar is on a distinguished road
Default diffrence between and constraints and triggers

what is the diffrence between and constraints and triggers?
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 07-12-2007, 03:00 AM
Murali Murali is offline
D-Web Master
 
Join Date: Feb 2007
Location: India-Chennai.
Posts: 386
Murali is on a distinguished road
Send a message via AIM to Murali
Default Re: diffrence between and constraints and triggers

Hi,

There are several different scenarios to mention the difference between the constraints and Triggers. Here is one ...

1. Constraints are found in the table to maintain the relationship between the same or different tables.
a. Primary Key
b. Foreign Key.
c. Check Constraint.
d. UNIQUE

2. Triggers are object found on the base table in which it has been created and fires on the specified conditions.
__________________
-Murali..
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is data integrity? Explain constraints? sundarraja Database Support 1 01-18-2008 03:41 AM
Failed to enable constraints problem... gp_logesh C# Programming 2 12-27-2007 04:00 AM
Difference between database triggers and form triggers? ragavraj Database Support 2 11-23-2007 03:54 AM
Difference between database triggers and form triggers vijayanand Database Support 0 09-20-2007 06:41 AM
Main Diffrence Between Perl with Php? senraj PHP Programming 2 08-11-2007 07:24 AM


All times are GMT -7. The time now is 11:52 AM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.

SEO by vBSEO 3.0.0