Answer / mahender achhe

Primary key does not allow the null values but where as in
unique key accepts the null values.

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.

Answer / arun prasad

ABOVE ITS WRONG FOR UNIQUE KEY, SORRY.

UNIQUE KEY REFERS TO THE NON-NUMERIC KEY .

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

Explain the difference between a pool table and a transparent table?

0 Answers  

---

When the system is getting slow. How can you get the message what is going wrong?

1 Answers   TCS,

---

What does the insert statement in extract datasets do?

0 Answers  

---

Wh bapi u have used in rfc?

1 Answers  

---

What are domains and data element?

3 Answers  

---

suppose i want to print sap script output in different printers at a time what are the settings i'll have to make?

0 Answers   Colgate,

---

What is going life actually? What is the role of a functional consultant in it? : sap abap hr

0 Answers  

---

How do you call a transaction from a report ?

3 Answers  

---

What is lock object ? : abap data dictionary

0 Answers  

---

What type of transport requests?

3 Answers   Wipro,

---

what is badi?

12 Answers   TCS,

---

What is the meaning of table buffer? This buffer is used by which type oftable?

0 Answers  

---