what is the different between unique+not null & primary key,
Answer Posted / 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 |
Post New Answer View All Answers
Why do we need databases?
what is innodb? : Sql dba
How can I delete duplicate rows?
Does sql view stored data?
What is sql architecture?
How do I partition in sql?
What is Materialized View? In What Scenario we Use Materialized View?
Can pl sql procedure have a return statement?
What is pl sql package?
How does cross join work?
Explain how exception handling is done in advance pl/sql?
What is the least restrictive isolation level? : Transact sql
What does 0 mean in sql?
What is the difference between function, procedure and package in pl/sql?
What does select count (*) mean in sql?