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 |
Name a few system global variables you can use in ABAP programs?
What are the disadvantages of abap query tool?
what is the use of 'split' in BDC? Is it related to some tab adjustment to the flat file during BDC?
What are the general naming conventions of ABAP programs?
I have 1 basic list and 9 secondary list in interactive report. If i am in 5th list, how can i come directly to the basic list?
How will you decide whether to use implicit enhancement or explicit enhancement?
What are the problems in processing batch input sessions?
What is sap abap tables?
How do u test a script?
what do u mean by one to one relationship in the database of transparent and many to one relation in pooled table could please tell me the answers i couldnt understand the concepts
how many main windows are there in scripts?
wat is the default file name of BAPI trace?