What are constraints? Explain different types of
constraints?
Answer Posted / rev
3 basic types
1.entity constraint:
check
not null
null
2.domain constraint:
unique
primary
composite primary key
3.referential constraint:
integrity
foreign
| Is This Answer Correct ? | 27 Yes | 28 No |
Post New Answer View All Answers
Why we should not use triggers?
What is for xml in sql server?
What are the differences between clustered and non-clustered index?
What program is used to store the data source file?
What is the difference between varchar and varchar types?
What are the different types of stored procedures?
What is function of ROLLUP ?
Can two tables have the same primary key?
What is the purpose of update statistics and scope_identity() function?
What are the main differences between #temp tables and @table variables and which one is preferred?
What is the fillfactor concept in indexes?
How do I port a number to sql server?
What is ms sql server service broker?
Can you leave a union at any time?
Define inner join in sql server joins?