What is the difference between constraints and triggers?
- 9 Answers
- 34188 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
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What new changes are being made in SQL Server?
How can you insert null values in a column while inserting the data?
What are the five characteristics of good data?
What is page-level compression?
What are temporal tables in sql server 2016?
What are the disadvantages of merge replication?
Explain what is it unwise to create wide clustered index keys?
How will you know when statistics on a table are obsolete?
How you would rewrite the sql query to return the customerid sorted numerically?
Define Joins?
Write a query for primary key constraint with identity key word?
What function does a database engine serve in the sql server?
What are the properties and different types of sub-queries?
What is t-sql script to take database offline – take database online.
