topic Re: database table without key fields in Application Development and Automation Discussions

database table without key fields

Former Member — Mon, 16 Mar 2009 08:24:01 GMT

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

Regards

Aditya

Re: database table without key fields

Sm1tje — Mon, 16 Mar 2009 08:28:34 GMT

Nope (No), only structures.

Just a suggestion:

Try before you....

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

Re: database table without key fields

Former Member — Mon, 16 Mar 2009 08:28:49 GMT

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

Re: database table without key fields

dev_parbutteea — Mon, 16 Mar 2009 08:29:47 GMT

Hi,

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

Regards.

Re: database table without key fields

Former Member — Mon, 16 Mar 2009 08:29:58 GMT

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

Re: database table without key fields

former_member222860 — Mon, 16 Mar 2009 08:30:41 GMT

It gives error with out key-field .

Key-field is mandatory

Re: database table without key fields

I355602 — Mon, 16 Mar 2009 08:31:36 GMT

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

Re: database table without key fields

Former Member — Mon, 16 Mar 2009 08:32:07 GMT

Hi Aditya,

No you cannot create a table without the key fields.

Regards

Mansi

Re: database table without key fields

Former Member — Mon, 16 Mar 2009 08:32:50 GMT

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

table without a key field.

Regards

Hareesh Menon

Re: database table without key fields

Former Member — Mon, 16 Mar 2009 08:35:06 GMT

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

Regards,

Joan

Re: database table without key fields

Peranandam — Mon, 16 Mar 2009 08:35:42 GMT

Hi,

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

Regards,

Peranandam