What are constraints? Explain different types of
constraints?
Answer Posted / aravindu chowdary
CONSTRAINTS:
*It is a rule (or) restriction ,which is enforced during a
creation of table.
*constraints raises automatically at the time of
inertion,updation,deletion.
*constraints there are 3 types
1.Domain Integrity
* Not null:Donot allow null value.
* check: Limits the range of values or domain, checks
the values which a col can have
2.Entity Integrity
* Unique key:donot allow duplicate values, but allows
one null per col.Can have multiple unique constraints on a
table
* Primary key : Ensure no duplicate data and not allow
nulls.
3.Refrential Intrgrity
*Forgien key:Referntial integrity b/w 2 tables, one
table col values based on other table col values
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Explain what are sparse columns?
What are the restraints imposed on the table design by a merge replication?
Why we use the openxml clause?
How can change procedure in sql server?
What are system databases in ms sql server?
What is database black box testing?
What is update locks?
What are the steps you should follow to start sql server in single-user mode?
Explain about merge replications?
What are trace files?
What happens if null values are involved in string operations?
Why is sql server log file full?
What is the name of the Database which IBM mainframe uses?
How would you choose between a clustered and a non-clustered index?
What is the difference between indexing and hashing?