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

Can we create table in function?

969


How do you go back in sql?

993


Can we use two order by clause in query?

970


Explain spool.

1186


Is postgresql a server?

1056


What is not equal in sql?

1132


What is trigger types in sql?

999


What is the purpose of cursors in pl/sql?

1139


What is type and rowtype in pl sql?

1021


how can we know the number of days between two given dates using mysql? : Sql dba

1049


What is java sql drivermanager?

1104


Are there any features that are decommissioned in 11g that are not present in 11g?

2150


How do you drop a trigger?

997


What has stored procedures in sql?

1070


How do I create a sql script?

1106