what is Primary key and unique key and what is the
Difference?
Answers were Sorted based on User's Feedback
Answer / mahender achhe
Primary key does not allow the null values but where as in
unique key accepts the null values.
Is This Answer Correct ? | 16 Yes | 3 No |
Answer / andsens
Fields in UNIQUE CONSTRAINTs can be NULL. They cannot with PRIMARY KEYs.
You can define more than one UNIQUE KEY in a table.
Because of this, the behaviour of UNIQUE CONSTRAINTs
is very different from PRIMARY KEY constraints.
As long as one of the fields in a UNIQUE CONSTRAINT is NULL
the constraint itself does not apply and you can set the other fields
to whatever you want without getting an error.
Is This Answer Correct ? | 5 Yes | 0 No |
ABOVE ITS WRONG FOR UNIQUE KEY, SORRY.
UNIQUE KEY REFERS TO THE NON-NUMERIC KEY .
Is This Answer Correct ? | 8 Yes | 4 No |
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 |
What is going life actually? What is the role of a functional consultant in it? : sap abap hr
how to transport abap workbench objects
What are the aggregate objects in the dictionary? : abap data dictionary
What type of variables normally used in sap script to output data?
3. After running a BDC program in background, next day morning when you see the results, few records are not updated(error records). What will you do then?
On which event we can validate the input fields in module programs?
How do you send the output of a script as an email attachment
If I want to execute a program only in background not in foreground is there any option for this? : abap bdc
What is its?
what is function group? Difference between function group and FM?
What is the difference between macro and subroutine?
does select single *.. / select * .. affect performance ? how?