what is difference between primary key and unique key
?
- 2 Answers
- 4042 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chandonline
Basic difference between primary key and unique is that primary key is used to define a table in other tables for preventing data from anomalies,and unique key is used in a table to apply unifications among different values or columns of a tables and only in that table obviously.Their is no usage of unique key outward a table but primary key is often used to make relations between other tables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ashish tyagi
The basic difference between primary key and unique key is that unique key allows null value but primary key did not allow null value.
| Is This Answer Correct ? | 2 Yes | 0 No |
What are the disadvantages of cursors? How can you avoid cursors?
What are the 18 schemas?
explain detail about ftp in datastage?
How long can an error message be in raiseerror function?
How can I detect whether a given connection is blocked?
What is dbms and its application?
What is the system function to get the current user's user id?
Explain about the storage and physical database design?
What is dbms explain in brief?
State the acid rules?
how to find the first two highest salaries in deptno in emp table
Explain the general syntax for a SELECT statements covering all the options.
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
