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 purpose of TNS?
can we delete autodiff back up that we have set through sql server agent.
How many indexes can be created on a table?
can u combine pipeline parallelism and partition parallalism? how and whan?
What is redis good for?
How to do Data integrity testing? Who does this testing (Developer or tester)?
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
how can we view column head in first page but not in remaining pages?
Can you tell any two advantages of stored procedures?
What is ase database?
What is Object Oriented model?
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
Write a query to get maximum and second maximum in oracle?
A design problem was given in which I was supposed to make a design for the data base for a given problem.
What is the difference between oracle and MS Access?