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 problem we face during development( if we say v are in support(development)? what are the critical problems araises during LSMW updation and Smart form layout development for involce and po? very very important questions now a days commonly asking..plz plz reply me

1542


What is an authorization in sap?

615


Explain what is the difference between sy-tabix and sy-index? Where it is used?

564


What are the fields in the memory table ‘screen’?

588


What are the uses of interactive reporting?

625






What will you code in start-of-selection & end-of-selection ?

595


SAP Script for Billing in which Billing document number was displayed as header, Bill Type, Bill Category, Bill Item, Cost, Base Unit of Measurement and Material number were categorically displayed for each billing document number. plz mention the detail coding Tahnks, Rahul

2097


What are the restrictions on subscreens?

646


Explain the Inportance of pa40? : abap hr

582


What are hashed tables?

873


How to upload more than 2GB file from External Source to SAP?

858


Define external layer?

637


Have you worked with support? How ticket comes to you? What were the timings for resolving tickets types of severity?

1617


What are the problems in processing batch input sessions?

607


What is is a match code? : abap data dictionary

685