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 |
How do you process errors in call transaction method? : abap bdc
How do you find if a logical database exists for your program requirements?
what is the difference between transparent, pooled and cluster table
what technology used at presentation layer for displaying GUI to SAP user ? and where those files were put?
Have you processed BDCs ?
What is the difference between Initialization and parameters ?
what is the keep parameter in BDC_OPEN_GROUP function module
What type of user exits have you written ?
WHAT ACTUALLY IS REAL TIME IMPLEMENTATION HOW MANY PHASES ARE THERE IN THAT
In a loop of an internal table, what is the use of at first & at last statements?
what is mean be On Change of in Control Break statement
explaine about factory calender.