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 are the differences between Database Trigger and
Integrity constraints ?

Answer Posted / rao

main diff is when we use the trigger voilation rules of
trigger body will not affect existing data.but in case of
constrinat will affect the exsting data also.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is update query?

990


how many groups of data types? : Sql dba

1029


What is restrict in sql?

1122


what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1072


What is pl sql and why it is used for?

1113


What is plpgsql language?

1068


Which one is better sql or oracle?

973


How can triggers be used for the table auditing?

1070


What is a clob in sql?

1026


What is the purpose of primary key?

1030


What is sql comments?

1077


When can we use the where clause and the having clause?

1021


What is a constraint? Tell me about its various levels.

1164


Can we create index on primary key?

973


Is natural join same as inner join?

946