how to creat a table with out primary key

Categories >> Software >> ERP CRM >> SAP >> SAP ABAP
Suggest New Category

Question Posted / poorna

10 Answers
21378 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to creat a table with out primary key..

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

how to creat a table with out primary key..

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

how to creat a table with out primary key..

Answer / roli t

create the table as it is; with using the keyword primary
in it.

Is This Answer Correct ?

4 Yes

1 No

how to creat a table with out primary key..

Answer / mb

why would you want a table without a primary key?

Is This Answer Correct ?

3 Yes

0 No

how to creat a table with out primary key..

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

how to creat a table with out primary key..

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

how to creat a table with out primary key..

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

how to creat a table with out primary key..

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

how to creat a table with out primary key..

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

how to creat a table with out primary key..

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

Post New Answer