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...

Difference between primary key and unique key ?

Answer Posted / ibrahim

PRIMARY KEY is identity of each row. UNIQUE KEY also
identity of each row.
PRIMARY KEY not accepts null values but unique can accept null.

but the core different between primary key and unique is we use primary key to link tow tables with each other but we can not use unique key to do this.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to bring a tablespace online?

1073


Explain the difference between sql and oracle?

1075


How to define and use table alias names in oracle?

939


What is data block in Oracle?

1114


How to do a full database export?

1104


Explain the difference between sap and oracle?

1029


What is the difference between post-database commit and post-form commit?

1191


How to define a data source name (dsn) in odbc manager?

1026


What privilege is needed for a user to create tables in oracle?

951


What to do if dba lost the system password?

1167


How to test null values?

1102


How do I use os authentication with weblogic jdriver for oracle and connection pools?

1047


Explain temporal data types in oracle

1093


How to retrieve values from data fields in record variables?

1109


What is meant by joins? List out the types of joins.

1024