what is primary key,unique key, foreign key? can u teach me
in simple language?
Answer Posted / rahul patil
PRIMARY key is one which uniquely identifies a row in the
table.
It does not has any null value entry.It can be formed by
using one or more fields of the table.If more fields are
used then the key is known as COMPOSITE key
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
What is a sequence? Explain it with one example?
Display the employees whose salary is less than average salary.
Explain partial key?
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
What is a trace file?
How to produce such kind of file?
What is the purpose of TNS?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
How default key is different from primary key?
What happens when shared and exclusive locks are applied on data item?
how can we view column head in first page but not in remaining pages?
What is odm database?
i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name
Can a database table exist without a primary key?
After normalization, what are the conditions which have to keep in mind to de-normalize it?