what is primary key,unique key, foreign key? can u teach me
in simple language?
Answer Posted / kranthi
primary key: primary creates a clustered index on the
column and it doesn't allow null values.
unique key: unique key creates non clustered index by
default.it allows "one null value".
foreign key: A foreign key (FK) is a column or combination
of columns used to establish and enforce a link between the
data in two tables
| Is This Answer Correct ? | 212 Yes | 76 No |
Post New Answer View All Answers
what is the full procedure for using store procedure in informatica7.1?
Explain about ur projets on teradata???
List the properties of a transaction.
How is image stored in database?
What is the advantage of varchar2 over char?
What is database server and how it works?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
What are the advantages of views in a database?
What is the difference between primary and candidate key?
Is database a hardware or software?
if i want to display the name of students such that to which city they belong must have count greaer than two
What are the most common databases?
What is relational database with example?
What happens when shared and exclusive locks are applied on data item?
List some advantages of dbms.