what is Primary key and unique key and what is the
Difference?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of data dictionary objects? : abap data dictionary

868


Kindly help me to Know the process of mapping in EDI from R/3 to a convertor(third party which translates IDoc flatfile to EDIFACT /XML / FTP /HTTP ) ?

1762


What are the types of windows in sap script?

794


How do we assign dynamic views while creating material master and generating bdc? : abap bdc

870


Where can you find error log for call transaction? : abap bdc

952


Difference between transparent tables and pooled tables? : abap hr

774


What is dialog module?

789


In the MM module for finding out the standard cost what is the view one has to look at?

806


What are the different types of internal table?

846


What is the difference between Classic badi and Kernal badi ?

2063


how to create view in bdc..??

2548


Can we use write statements in screen fields?if not how is data transferred from field data to screen fields?

755


hi i need detailed information on badi and bapi how can this work in real time senarios plz explain with exp

3400


What is new enhancement framework?

1074


What are client dependant objects in abap/sap?

865