Interested to Buy Any Domain ? << Click Here >> for more details...
what is the different between unique+not null & primary key,
- 4 Answers
- 7574 Views
- I also Faced
- E-Mail Answers
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
what is an extent ? : Sql dba
What are the uses of sysdate and user keywords?
What is the max nvarchar size?
Can I create table without primary key?
Is left join inner or outer by default?
what is csv? : Sql dba
What is rename in sql?
what is “go” in t-sql? : Transact sql
How to disable a trigger name update_salary?
What is pls_integer in pl sql?
Why do we use subquery?
what are local and global variables and their differences? : Sql dba
Explain the commit statement.
What is oracle pl sql developer?
What is the main difference between sql and pl/sql?
