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 constraints and triggers?

Answer Posted / malini paul

1.Constraint is a statement about a database that is always
true.Whereas triggers constrain what a transaction can do.

2.Constrain applies to existing data in the table and any
statement that manipulates the table.Whereas Trigger does
not apply to data loaded before the trigger was created.

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is usually the first word in a sql query?

1126


What is indexing in sql server with example?

994


What is an index. What are the types?

1080


How to drop an existing stored procedure in ms sql server?

1024


Does an index slow down updates on indexed columns?

967


What is thr feature of change data capture?

973


Differentiate sql server reporting services vs. Crystal reports?

200


tell me what is blocking and how would you troubleshoot it? : Sql server database administration

895


How do you delete a data source?

1002


What does it mean to invest in the index?

957


How do I find query history in sql server?

935


What is 4nf in normalization form?

1015


What are the difference between data mart and data warehouse? : sql server analysis services, ssas

954


How to make a remote connection in a database?

969


What is the latest version of microsoft sql server?

1038