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
- 189042 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / subin
PRIMARY KEY - is a constraint(restriction) placed on one or a group of more than one columns of a table by the database admin (who does so while creating the table) that the value(s) of this column(s) will never be duplicate ensuring that every record(row) of the table is a unique one.
# There can only be a single primary key for a table. Hence the name primary key.
# This is the key used by foreign keys of other tables
to identify a unique record of this table.
# null value cannot be given to columns of primary key as
it will not ensure uniqueness of the record.
UNIQUE KEY - is a constraint on one or group of columns that
disallows duplication of records. It differs from primary key in that
# no restrictions to number of unique keys for a table.
# depending on different database software being used
one or many records can have null values.
FOREIGN KEY - constraint placed on certain column(s) of a table ensuring that the set of value(s) in theese column(s) will uniquely identify a record in a mentioned foreign table (mentioned while defining foreign key)that should be aptly associated with this record of this table.This is achieved with the help of primary key of the foreign table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the advantage of varchar2 over char?
How do I setup a database connection?
Which three commands cause a transaction to end?
What is the difference between database and server?
How to do Stored procedure testing? Who does this testing (Developer or tester)?
How is image stored in database?
What are the most common databases?
Which database does facebook use?
Explain data independence & its types.
What is the best database?
What is the difference between primary key, foreign key and candidate key?
What do you mean by foreign key and primary key?
Can we use redis as database?
How does non-cluster index functions?
What is the best database software for small businesses?
