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
- 189063 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / doraswamy
One table allows only one primary key but there is no
restriction for unique keys.
These two are same but one difference is unique key will
allow nulls.
Primary key create on a combination of mulitiple colums.
Foreign key is reference of another table primiary key. It
will not allow null values.
~Doraswamy
| Is This Answer Correct ? | 106 Yes | 43 No |
Post New Answer View All Answers
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
Differentiate between unique key and foreign key?
Which database does facebook use?
5. Explain about relational algebra.
give a simple example of physical and logical data independence
What is a Transformation?
What are the advantages of normalizing a database.
What is a trace file?
What is the relationship that exists inside in E-R diagram?
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
Define stored procedure?
How do I setup a database connection?
can we delete autodiff back up that we have set through sql server agent.
issues involved in modeling and building data werahouses
How to do Data size testing? Who does this testing (Developer or tester)?
