what is the different between unique+not null & primary key,
- 4 Answers
- 6361 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
How do temporal tables work?
what is a foreign key ? : Sql dba
What is substitution variable in pl sql?
what are the types of subquery? : Sql dba
What is PL/SQL Records?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What does select * from mean in sql?
Should I use mbr or gpt?
What is a join query?
What is the use of index in sql?
What is sql catalog?
Does truncate release storage space?
Can a table have no primary key?
Does sap use sql?
What is a loop in sql?
