Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 66438 Views
- A1 Technology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / praveen hr
UNIQUE Constraints
You can use UNIQUE constraints to make sure that no
duplicate values are entered in specific columns that do
not participate in a primary key. Although both a UNIQUE
constraint and a PRIMARY KEY constraint enforce uniqueness,
use a UNIQUE constraint instead of a PRIMARY KEY constraint
when you want to enforce the uniqueness of a column, or
combination of columns, that is not the primary key.
Multiple UNIQUE constraints can be defined on a table,
whereas only one PRIMARY KEY constraint can be defined on a
table.
Also, unlike PRIMARY KEY constraints, UNIQUE constraints
allow for the value NULL. However, as with any value
participating in a UNIQUE constraint, only one null value
is allowed per column.
A UNIQUE constraint can be referenced by a FOREIGN KEY
constraint.
Link from MSDN http://msdn.microsoft.com/en-
us/library/ms191166.aspx
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what is a primary key? : Sql dba
Does sql between include endpoints?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
Can you inner join the same table?
What is sql exception?
What is t sql used for?
How do you use a while loop in pl sql?
What is %type in pl sql?
What are the advantages of stored procedure?
How do I upgrade sql?
Is it possible to pass parameters to triggers?
Do stored procedures prevent sql injection?
What is Histogram?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is sql query limit?
