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 and unique key and what is the
Difference?

Answer Posted / arun prasad

PRIMARY KEY IS A FIELD WHICH IS USED TO IDENTIFY THE TABLE
AND THESE CANNOT BE CHANGED, IF IT IS CHANGED THE DATA
INTEGRITY WILL GET LOST.

UNIQUE KEY IS A GROUP OR A SINGLE FIELD WHICH IS USED TO
REPRESENT THE NUMERIC FIELDS WHICH DOESNT CHANGE.
THE GROUP OF NUMERIC FIELDS IS THE UNIQUE KEY.

PRIMARY KEY IS USED FOR DATABASE TABLES WHERE AS UNIQUE KEY
IS USED FOR INTERNAL TABLES.

Is This Answer Correct ?    4 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the problems in processing batch input sessions? How is batch inputprocess different from processing online?

1126


What is the major difference between pool tables and transparent tables?

1181


What is the role of ‘refresh’ in internal table?

1103


what is the difference between hashed & sorted internal tables?

2273


Difference between call by value and call by reference? : abap data dictionary

1130


Power is interrupted while transferring data from internal table to application server. How will you determine many records are transferred in session method and call transaction method? : abap bdc

1351


What is roll area?

1071


What are screen painter and menu painter? : abap hr

1096


How to convert normal function module to bapi?

2110


What are internal tables? How do you get the number of lines in an internal table? How to use a specific number occurs statement?

1123


8)when u create sales report what u can see in that report ? what rthose field names or data element names? 9)when u create purchase order details report what u can see in that report ?what rthose fieldnames or dataelements? 10)when u create material stock report in material master grouped by material type and plant what u can see in report ?what rthose field names or dataelement ? 11)when u create shipping forecast report what u can see in that report ?what rthose data elements or field names?

2160


Can anyone done BDC/LSMW/BAPI for F-02 and F-04.If yes let me know the processs

2565


What are the different kinds of lock modes?

1102


what is the t-code to link technical and functional operation?

2485


Explain the difference between a pool table and a transparent table and how they are stored at the database level?

1193