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
- 187578 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
Which database does facebook use?
What is database client?
can u combine pipeline parallelism and partition parallalism? how and whan?
What is the function of cluster index?
What are different types of joins used in?
What is odm in database?
What are database connection details?
Explain file manager?
What is the DIF format and when we will use in teradata
What are indexes in oracle?
What is the purpose of firebase?
What is difference between clustered, non-clustered and unique index?
Explain natural key?
What is a database string?
A design problem was given in which I was supposed to make a design for the data base for a given problem.
