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
What is #table in sql server?
What are the different types of collation sensitivity?
Explain collation?
What are the different types of locks in the database?
What is the difference between dbcc indexdefrag and dbcc reindex?
What is the optimization being performed in oracle and SQL Server?
How the authentication mode can be changed?
Explain the disadvantages/limitation of the cursor?
What is a primary key?
Explain the commands in sql server?
What are horizontal and vertical scaling?
What is the difference between a function and a stored procedure?
Can you explain powershell included in sql server 2008?
if no size is defined while creating the database, what size will the database have? : Sql server administration
what is a self join? Explain it with an example? : Sql server database administration