what is Primary key and unique key and what is the
Difference?
- 4 Answers
- 18157 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 4 Yes | 13 No |
Post New Answer View All Answers
What is the difference between tables and structures?
What is view? Different types of view.
What two statements are required in an abap program to output an icon using a write statement?
GUYS any one please can u post questions in sap a bap webdynpro questions.. please i need to know some technical questions regarding webdynpro and ADOBE forms ?
What was the requirement of IDoc in your project? How it was working?
If i wont like to change the standard print program where i copied standard script to customer namespace,in this case is it possible to retreive the data if u connect the script with standard program.if yes how?if no why? Is it possible to print the logo in first page only,where the form consists of 10 pages.How can u do this? How can u set a table format where it cosists of fields like cust no, custname, amount ...in a script? How do u know that the particular BADI is suitable for the existed report.How do u findout this?When do u opt for BADI OR USEREXIT?did functional people tell u to adopt BADI or USEREXIT? What is the difference between SY-INDEX & SY-TABIX ? I have a report with fields Status,time & date. the contents it consists are Status Time Date AAA 01:20:15 05-06-10 AAA 11:02:32 O3-06-10 AAA 23:11:00 05-06-10 AAA 09:14:46 05-06-10 HOW DO U WRITE A CODE TO DISLAY A ROW WHICH WAS RECENTLY EXECUTED?( for this question it should display AAA 23:11:00 05-06-10 AS Output)
What are the functional modules used in sequence in bdc? : abap hr
Can i Have Some Realtime Examples on Badi ?
How to add a column to a table control while using alphanumerical layout editor ?
What is constructor expression in nw abap 7.4?
ALV Report that will show the details of order like order no, order date, customer, product code & description, order quantity and value along with the details of dispatch of those orders like invoice no, invoice date, invoice quantity and pending order quantity. plz mention the detail coding Tahnks, Rahul
Power is interrupted while transferring data from internal table to application server. How will you determine many records are transferred in session method and call transaction method? : abap bdc
Explain what is an rfc?
What is a match code? : abap data dictionary
What are the types of search helps? : sap abap data dictionary
