Interested to Buy Any Domain ? << Click Here >> for more details...
what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 189057 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sanjeev goud
Primary key - Primary key means main key
def:- A primary key is one which uniquely identifies a row
of a table. this key does not allow null values and also
does not allow duplicate values. for ex,
empno empname salary
1 sanjeev 35000
2 rakesh 34000
3 chintoo 40000
it will not the values as follows:
1 sanjeev 35000
1 rakesh 34000
chintoo 35000
Unique key - single and main key
A unique is one which uniquely identifies a row
of a table, but there is a difference like it will not
allow duplicate values and it will any number of allow
null values(In oracle).
it allows only a single null value(In sql server 2000)
Both will function in a similar way but a slight difference
will be there. So, decalaring it as a primary key is the
best one.
foreign key - a foreign key is one which will refer to a
primary key of another table
for ex,
emp_table dept_table
empno empname salary deptno deptno deptname
In the above relation, deptno is there in emp_table which
is a primary key of dept_table. that means, deptno is
refering the dept_table.
| Is This Answer Correct ? | 16 Yes | 7 No |
Post New Answer View All Answers
What is a sequence? Explain it with one example?
Differentiate between unique key and foreign key?
What is the difference between database and server?
What are the types of indexes that are present inside a database?
What are different types of resources?
What are different types of joins used in?
Write a query to retrieve for many to many relationships?
How concurrency problems effect the database?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
Is database a hardware or software?
WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?
Data structure used to implements a menu:
how node connect with cpu?
What is redis good for?
5. Explain about relational algebra.
