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 / 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 is the difference between sy-tabix and sy-index? Where it is used?

1281


How can we use / display table in a screen?

1095


Which function module reads the data for particular infotype ? : abap hr

1054


What are field symbols and field groups? Have you used component idx of structure clause with field groups?

1023


Explain what is an rdbms?

1019


What is the use of dequeue function module? : sap abap data dictionary

1138


Explain the different types of view?

1005


What is the modification assistant?

994


What is bdc programming in sap?

1090


Define spool request?

1085


Can you delete data element, which is being used by table fields. : abap data dictionary

1123


How do you move on to the next screen in interactive reporting?

1162


What is the purpose of creating symbolic a/c, what is transaction code for same? Can we assign one symbolic a/c to multiple wage types? : sap abap hr

1277


What data is contained? : abap data dictionary

1110


How to add a column to a table control while using alphanumerical layout editor ?

2409