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 |
what is the difference between at first & at new statements ?
What are the FM you used in Session method?
I have more than one layout in a form, would You handle?
Hi, Can any one help me. i have a dropdown list box with values like LG01 SAMPLEDRAW LG02 LASER......... Like this i have multiple values .and my table name is T496N. Whenever i select ex:lgo1 sampledraw the program title should be change with SAMPLEDRAW(With out execute f8 button). Thanks and Regards
what are the table controls in BDC ?
1 . how do u design technical documentation in abap ? 2 . what u currently devloped in sap abap ?
what is the use of FOR ALL ENTRIES in an internal table?
9 Answers Keane India Ltd, PCS, Wipro,
how can we print both side in smartforms?
what is defference between repository and non repository Object?
How did you transfer legacy data in the mid of the financial year (us) to the sap system? : sap abap hr
What are the different kinds of lock modes?
What is an Extended IDOC and It's purpose?