Interested to Buy Any Domain ? << Click Here >> for more details...
what is the different between unique+not null & primary key,
- 4 Answers
- 7615 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 does varchar include?
How do you remove duplicates without using distinct in sql?
Explain the difference between rename and alias?
explain what is mysql? : Sql dba
what is isam? : Sql dba
How to read/write files from pl/sql?
What is sql and also describe types of sql statements?
Is microsoft sql free?
Why plvtab is considered as the easiest way to access the pl/sql table?
How do I upgrade sql?
What is not in sql?
What are different types of sql commands?
What is the difference between cluster and non-cluster index?
explain the difference between bool, tinyint and bit. : Sql dba
what is a database transaction? : Sql dba
