how to creat a table with out primary key
Answers were Sorted based on User's Feedback
Answer / smart varghese
I think it is not possible to create a transparent table
without a primary key
Is This Answer Correct ? | 12 Yes | 1 No |
Answer / venkatesh
mr Prabhu
u are wrong, we can't create table without Primary Key
using built in type too
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / roli t
create the table as it is; with using the keyword primary
in it.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / archana.p
we can create table without a primary key.It is simple
like create table test(testid varchar2(20),tname varchar2
(20));
But the table without aprimary key may not have any
significance
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / sunny
A table can be created without using the primary key.
first understand why we use primary key on a table:-
1.in order to avoid inserting of duplicate values in a table,we use primary key,we can create a table with different values.
2.in order to establish the relation with other table by the use of primary key in parent table and foreign key in child's...without establishing the relation with any other table also ,we can create a table without having any primary key
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / prabhu kiran
yes , it is possible to create table without primary key
like that.....
fieldname type values
eno int2 defualt value
ename char 30
sal flt defualt value
then select builtin type.
these table can't migrated from one to other.
it's act like transparent table , but standalone.
whenever we create these table , we loss a valueble time.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / prabhu das
Hai Venkatesh,
i know but i was mistaked.
whenever going to create tables. these are two types.
client dependent and client independent.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mayuri
We have to specify the primary key while creating table.
with out primary key we cant create table
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / umesh tiwary
it is not possible to create a table without primary key
while checking the table it will show a error please
specify a primary key
Is This Answer Correct ? | 2 Yes | 3 No |
2)what is the differnce between user exits and Badi
Can i Have Some Realtime Examples On Modulepool programming.
How to debug a sapscript?
What is the client concept in sap?
If there are two table with Foriegn Key relationship, and if any changes is made to the check table in Table Maintanance Generator how will this the other table?
difference between bapi and rfc
Explain what is sap script? What is the purpose of sap script?
CAN U TELL ME ATTRIBUTES OF BOTH DOMAIN AND DATAELEMNT SCREEN?
what is the role of ST05 in performance tuning?
explain about step loop and table control.
What is the reason, a BDC program is working in 'A' mode but not in 'N' mode ?
What are the two ways for restricting the value range for a domain? : sap abap data dictionary