table without primary key

[Former Member]

can v create table without primary key???

can v activate it and access it??

can v create entries in 2 tat??

if yes,wat ll be the use???

[Former Member]

we cant create a table without the primary key

[Former Member]

A table cannot be created without a primanr key. ReaSON, Primary key identifies a unique record of the DB table and if there is no primary key there is no unique record. This is how it is defined in the RDBMS concepts

[Former Member]

hi,

we cant creat table wit primary key when we crate an table the sys will ask to specify an primary key.

ravi

[former_member873340]

You need to specify atleast one primary key in ur table....

u cannot activate it ...wil throw up a error saying

ZTEST_TABLE(specify a primary key)

Field of type CLNT not a key field. (Table is not client-specific)

Table ZTEST_TABLEmust be created in the database

Check on table ZTEST_TABLE resulted in errors

[Former Member]

no i tried it ..it got activated..

[Former Member]

Dude pls check it once again...

There is no such compulsion on creating p key u can create table without pkey.

sunny

[Former Member]

Hi Kota,

We should not and we can't create table woth out primary key. If u try to activate the table with out primary key then error will be triggered like primary key does not exist in the table like that.Please close the thread if u update with answer.

Hope this helps you, reply for queries, Shall post you the updates.

Regards.

Kumar. .

[Former Member]

no i tried it ..it got activated.. have u tried it???

[Former Member]

initially it accepts...n take values.. but later .. if u want to relate this table with another u ned to havea primary key concept.. in this sisuation we create a primary keep ..

[former_member873340]

hey its not possible....

surely it will throw an error.....

i am saying u dont use adjust and activate

[Former Member]

k

[Former Member]

hi,

We can't create table with out a table. If we try to create a table with out primary key, while checking syntax check it will through error that primary key is not defined because table is created in database. Primary key is used to uniquely identify the record. If we don't mention it then it will give error.