what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 180284 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / priya reddy
primary key- if a column is declared as priamry then there
wont be any repeated values in that column throughout that
table, as well as it wont take any null values and we can
use primary key only once in a table. but we can declare
combination of two columns as primary key.
unique- if a column is declared as unique then again there
wont be any repeated values in that column, but this will
take null values and even we can declare more thatn one
unique column in a table.
foreign key-if a column is declared with this key then we
have to use a reference ie we need to give the column which
will have the same values as this column and the table that
column belongs to.. this referced column of other table
will be the primary key of that table.
| Is This Answer Correct ? | 379 Yes | 91 No |
Post New Answer View All Answers
how can we view column head in first page but not in remaining pages?
What is the difference between oracle and MS Access?
please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks
can we delete autodiff back up that we have set through sql server agent.
diff b/w inter process and in process
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
WHAT IS CARDINALITIES OF JOIN?
Is database a hardware or software?
what is the role of auditor in auditing data oriented applications?
What are the tools used for backup and ticketing?
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
A design problem was given in which I was supposed to make a design for the data base for a given problem.
issues involved in modeling and building data werahouses
What is aws documentdb?
What is ole db provider for sql server?
