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 |
In ALV reporting when u execute your report which event gets triggered.
Functionality of Edit call..?
What is the difference between the function module and a normal abap/4 subroutine?
How to read files and process BDC's automatically ?
Why is smart form more preferred printing utility than sap script ?
What is wage type
Performance techniques?
How does the inventory get reduced after the delivery?
What is table maintenance generator?
Shall we use the tables existing in the system for related applications directly (by directly selecting from the database in the pgm) What is the common practice in industries regarding the same? Can anybody help me?? THANKS IN ADVANCE
how to copy standard sap program to z program
In the abap/4 dictionary tables can be defined independent of the underlying database (t/f). : abap data dictionary