what is difference between primary key and unique key
?
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 |
Explain about post-relational databases?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
how will I find the duplicate rows count from employees tablein oracle.
How to read and create .LDC data files which are used by linguatic dictionary.
What are the main phases of database development?
can you give me the syntax of named procedure??
Explain about the database management systems.
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
1 Answers Flextronics, Hexaware, SQL Star,
Which four data types cannot be used as a return type from a user-defined function?
Write the fastest query to find out how many rows exist in a table?
How long can an error message be in raiseerror function?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)