What is the difference between constraints and triggers?
- 9 Answers
- 34937 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
What is the difference between writing data to mirrored drives versus raid5 drives
What is the difference between primary key and unique constraints?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What are logical/boolean operations in ms sql server?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What are different types of statement?
What command is used to rename the database?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
How to delete duplicate rows?
What are .mdf files?
Define candidate key, alternate key, and composite key.
Explain what are the restrictions that views have to follow? : SQL Server Architecture
How to find out the list schema name and table name for the database?
