Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

database table without key fields

Former Member
0 Likes
2,637

Hi

Is it possible to make database table without key fields. Please let me know if possible.

Regards

Aditya

1 ACCEPTED SOLUTION
Read only

Sm1tje
Active Contributor
0 Likes
1,726

Nope (No), only structures.

Just a suggestion:

Try before you....

Edited by: Micky Oestreich on Mar 16, 2009 9:28 AM

10 REPLIES 10
Read only

Sm1tje
Active Contributor
0 Likes
1,727

Nope (No), only structures.

Just a suggestion:

Try before you....

Edited by: Micky Oestreich on Mar 16, 2009 9:28 AM

Read only

Former Member
0 Likes
1,726

HI,

i just tried it, It is not possible to create a table with out primary key. a table must have atleast 2 keys fields.

thanks& regards,

kat

Read only

dev_parbutteea
Active Contributor
0 Likes
1,726

Hi,

No you cannot. You will have an error if you do not specify the key .

Regards.

Read only

Former Member
0 Likes
1,726

You cannot create a table without Primary key specification.

Moreover, in a relational Database, a table without any key doen't make any sense.

- RJ

Read only

former_member222860
Active Contributor
0 Likes
1,726

It gives error with out key-field .

Key-field is mandatory

Read only

I355602
Product and Topic Expert
Product and Topic Expert
0 Likes
1,726

Hi,

You cant create a table with out primary keys.

A table must have atleast 2 keys fields (mandt and any other field) to form a composite primary key.

However you can create a structure without primary key.

Hope this helps you.

Regards,

Tarun

Read only

Former Member
0 Likes
1,726

Hi Aditya,

No you cannot create a table without the key fields.

Regards

Mansi

Read only

Former Member
0 Likes
1,726

Hi

you can create a database table without CLIENT field but you cannot create a

table without a key field.

Regards

Hareesh Menon

Read only

Former Member
0 Likes
1,726

You can not create a table without keys fields. Atleast 2 keys fields is mandatory.

Regards,

Joan

Read only

Peranandam
Contributor
0 Likes
1,726

Hi,

It is not possible to create table without key fields. Tell me your business process. So that we can help you

Regards,

Peranandam