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 difference between trigger and constraint?

Answer Posted / kumar jabu

Constraints implements specific conduct or rules on table column like it determines whether field data should be unique,not null ..
But triiger implements rules on systems or application event.
whenever dml occurs that implemented rules been fired.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is normalization important?

1005


How do you use join?

920


Does sap use sql?

961


Is sql difficult?

1141


what are the drivers in mysql? : Sql dba

1006


What is the difference between partition and index?

966


what are myisam tables? : Sql dba

1014


what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1129


How many row comparison operators are used while working with a subquery?

1016


What is parallel hint?

1299


What is record in pl sql?

1059


what is the difference between sql and t-sql? : Transact sql

1072


What is data definition language?

1080


What is a primary key sql?

1032


What does over partition by mean in sql?

957