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 / mudigouda patil

PRIMARY KEY
1)TABLE CAN NOT HAVE MORE THAN ONE PRIMARY KEY.
2)PK DOES NOT ALLOW NULL VALUES.
UNIQUE KEY
1)TABLES CAN HAVE MORE THAN ONE UNIQUE KEY.
2)UNIQUE KEY ALLOWS NULL VALUES.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you have more than one content canvas view attached with a window ?

2330


How to define an external table with a text file?

1062


In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4167


How to define a cusotmer as a supplier in ORACLE R12

2228


Explain an exception and its types?

1073


What is the difference between $oracle_base and $oracle_home?

1084


What is data block in Oracle?

1114


What is execute immediate in oracle?

1015


How to start instance with a minimal initialization parameter file?

1037


How to enter a new row into a table interactively?

1008


How to create a table index?

1143


How to get maxsal , minsal, ename department wise in single query

1549


How many anonymous blocks can be defined?

1182


How to view the tablespaces in the current database?

973


Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2310