what is primary key,unique key, foreign key? can u teach me
in simple language?
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
Differentiate between extension & intension?
Explain storage manager?
can we delete autodiff back up that we have set through sql server agent.
How do you pass parameter in stored procedure?
What is a database call?
What are the concurrency problems a database faces?
What is the use of graph database?
There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?
What is the difference between database and server?
What is database schema name?
Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar
What do you mean by foreign key and primary key?
what are wrappers and build ups and what it's use?
Explain phantom deadlock?
What is difference between clustered, non-clustered and unique index?