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
- 186579 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sandeep beniwal (master)
Primary key:- Primary key means main key. A primary key is
one which uniquely identifies of a table. Prrimay key does
not allow null values and duplicate values.
e.g:
empno empname status
10 dipender active
20 nisha inactive
30 vikas active
40 naveen active
Pimary key not like this:
10 dipender active
20 nisha inactive
30 vikas active
naveen active ........ (duplicate value)
Unique key:-A unique is one which uniquely identifies a row
of a table, but there is a difference like it will allow
only one duplicate values (In sql).
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 and helps making link
e.g
employee_table user_table
empID empname status userID userID empname
10 dipender active 1 1 dipender
20 nisha inactive 2 2 nisha
30 vikas active 3 3 vikas
40 naveen active 4 4 naveen
In the above relation, userID is there in employee_table
which
is a primary key of user_table. that means, userID is
refering the user_table.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the best database software for small businesses?
What is ole db source in ssis?
hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com
What is database schema name?
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
How to shrink a database?
What is a driver in database?
what is tkprof tool and how it is used???
can we delete autodiff back up that we have set through sql server agent.
List the properties of a transaction.
What the various ways to tune a teradata query
i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
What is table scan and index scan?
give a simple example of physical and logical data independence
