Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the Diff b/w Constraints and Trigeer

Answer Posted / shekar

Triggers: It checks the condition and Performs some action
eg: it checks and fires before or after insert or update
or delete

Constriants: it checks the condition
eg: suppose NotNull constraint.It jst doesn't allow null
values.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is left join same as join?

939


How do I upgrade sql?

949


What are secondary keys?

923


What is the use of triggers?

982


How many scalar data types are supported in pl/sql?

978


What is an intersect?

1047


What is server name sql?

1070


In a distributed database system, can we execute two queries simultaneously?

998


Can we rollback truncate?

947


How do you create an update query?

917


What are the subsets of sql?

1038


Define implicit and explicit cursors.

1076


What is self-join and what is the requirement of self-join?

1089


Is it mandatory for the primary key to be given a value when a new record is inserted?

1139


How do I run sql profiler?

1008