what is the different between unique+not null & primary key,
Answers were Sorted based on User's Feedback
Answer / sreekumar
In a relation, we can create only one primary key where as we can create multiple unique+not null constrains.
Primary key uses clustered index where are unique +Not null uses non clustered index.
Sreekumar
Is This Answer Correct ? | 18 Yes | 1 No |
Answer / suresh babu
Unique:
Unique is a constraint,which doesn't allow the duplicate
values and allow only one null value.We can create more
number of unique constraint in single table.
Not Null:
Not Null constraint,which doesn't allow the Null values and
allow the duplicate values.
Primary Key:
We can create one primary key for a table,Which doesn't
allow the duplicate and null values,and used for make a
foreign key relation.we can't do this process using above
two constraints.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / mohan babu
A unique key is nothing but it does not allow any
duplicateds but allows nullvalues
A primary key is nothing but it does not allow duplicates
as well as Null values i.e Not Nulls
Is This Answer Correct ? | 5 Yes | 5 No |
Answer / giri
unique:it does not allow duplicate values but it allow null values.
not null:It does not allow null values but allow duplicate values.
primary:It does not allow both duplicate and null values.
Is This Answer Correct ? | 0 Yes | 0 No |
What is an inconsistent dependency?
what is offset-fetch filter in tsql? : Transact sql
What problem one might face while writing log information to a data-base table in pl/sql?
Why do we use cursors?
What are data types in pl sql?
what does it mean to have quoted_identifier on? : Sql dba
how to create object in plsql
Can a view be mutating? If yes, then how?
What is normalization? How many normalization forms are there?
How will you select unique values from a list of records?
table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?