Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

What is the purpose of TNS?

1034


can we delete autodiff back up that we have set through sql server agent.

2202


How many indexes can be created on a table?

1154


can u combine pipeline parallelism and partition parallalism? how and whan?

2336


What is redis good for?

957


How to do Data integrity testing? Who does this testing (Developer or tester)?

2109


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

1981


how can we view column head in first page but not in remaining pages?

2043


Can you tell any two advantages of stored procedures?

1058


What is ase database?

1021


What is Object Oriented model?

1037


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

1844


Write a query to get maximum and second maximum in oracle?

1049


A design problem was given in which I was supposed to make a design for the data base for a given problem.

1085


What is the difference between oracle and MS Access?

1071