What is differance unique key and primary key.
- 7 Answers
- 10304 Views
- EDS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rahul khanke
primary key : primary key dose not except null value
unique key : it accept null values.. if it set to not null
then it as good as primary key.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / hema
Unique :: it does not allow duplicate values but allows
null values.
Primary:: Primary does not allow duplicate values as wel as
it dosnt allow null values.
unique+not null==Primary key...
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / dhanashree
Unique Key can be NULL
But
Primary Key can not be NULL
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / madhu
unique key:
1.unique key will accept more than one null value.
2.whenever u created a unique key, then internally one non-clustered index will be created(one table can have more than one Non-clustered index).
3.one table can have more than one unique key.
Primary key:
1.One table should have one primary key only.
2.primary key will not accept null values.
3.whenever u created a primary key then internally one clustered index will be created(one table can have only one clustered index).
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gourvendra singh
Unique : One or more unique key in a table,
allow only one null in the field.
Primary :Only one primary key in a table and u cannot
insert null into it.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / nagurthilak
Through Unique key we cant establish the relation between to
two tables but from primary key it is possible
| Is This Answer Correct ? | 3 Yes | 4 No |
Answer / l..l.n.reddy
PRIMARY KEY:- only one primary key in a table.
UNIQUE KEY:- One or more unique key in a table.
| Is This Answer Correct ? | 1 Yes | 3 No |
Is sql a case sensitive language?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is integrity constraints?
How bulk collect improves performance?
How to run sql functions in pl/sql?
Does pl/sql support create command?
how mysql optimizes distinct? : Sql dba
What is faster join or subquery?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is string data type in sql?
what is the difference between delete and truncate commands? : Sql dba
What is a unique key?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
