Interested to Buy Any Domain ? << Click Here >> for more details...
what is the different between unique+not null & primary key,
- 4 Answers
- 7780 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
Can we use views in stored procedure?
Explain the uses of control file.
What does plv msg allows you to do?
Why we use join in sql?
Compare sql & pl/sql
Does mysql support pl sql?
Is sql dba a good career? : SQL DBA
What problem one might face while writing log information to a data-base table in pl/sql?
Mention what does the hierarchical profiler does?
What is sql query limit?
how to drop an existing table in mysql? : Sql dba
Are stored procedures compiled?
What is difference between inner join and self join?
How do I install sql?
How do I make sql search faster?
