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 / vampire007

I dont' think Triggers are performanc wise more superior to
constraints. Constraints are isolated to table level
whereas triggers are flexible to do the validation on any
number of tables.

Is This Answer Correct ?    6 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is #table in sql server?

1028


What are the different types of collation sensitivity?

1094


Explain collation?

1049


What are the different types of locks in the database?

909


What is the difference between dbcc indexdefrag and dbcc reindex?

966


What is the optimization being performed in oracle and SQL Server?

1028


How the authentication mode can be changed?

1111


Explain the disadvantages/limitation of the cursor?

940


What is a primary key?

934


Explain the commands in sql server?

1018


What are horizontal and vertical scaling?

170


What is the difference between a function and a stored procedure?

1047


Can you explain powershell included in sql server 2008?

923


if no size is defined while creating the database, what size will the database have? : Sql server administration

973


what is a self join? Explain it with an example? : Sql server database administration

921