What is the difference between constraints and triggers?
- 9 Answers
- 33481 Views
- Wipro, I also Faced
- E-Mail Answers
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
How to view the error log for any specific instance? : sql server database administration
What is amo? : sql server analysis services, ssas
What is difference between rollback immediate and with no_wait during alter database?
How many types of functions are there in sql server?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Can we use where clause in union?
Are null values the same as that of zero or a blank space?
How do I view a trc file?
What is partition in sql server?
What do you need to connect php to sql server?
Explain what is the difference between a local and a global temporary table?
What are the steps to insert a table?
What is the difference between Normalization and De-normalization?
What does the not null constraint do?
Does partitioning help performance?
