Can we use more than one null value for unique key?
- 31 Answers
- 60709 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 an invalid partition table?
What is the primary use of normalization?
How do you rename a table in sql?
How to place comments in pl/sql?
What is primary and foreign key?
Show code of a cursor for loop.
How to return multiple rows from the stored procedure?
What are the different types of database management systems?
How do you clear the screen in sql?
What is the difference between python and sql?
Can a select statement fire a trigger?
What is prepared statement in sql?
How many developers work on postgresql?
How do I truncate a sql log file?
What does fetching a cursor do?
