topic table without primary key in Application Development and Automation Discussions

table without primary key

Former Member — Thu, 12 Apr 2007 06:37:44 GMT

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???

Re: table without primary key

Former Member — Thu, 12 Apr 2007 06:39:17 GMT

we cant create a table without the primary key

Re: table without primary key

Former Member — Thu, 12 Apr 2007 06:40:38 GMT

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

Re: table without primary key

Former Member — Thu, 12 Apr 2007 06:41:07 GMT

hi,

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

ravi

Re: table without primary key

former_member873340 — Thu, 12 Apr 2007 06:41:35 GMT

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

Re: table without primary key

Former Member — Thu, 12 Apr 2007 06:43:19 GMT

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. .

Re: table without primary key

Former Member — Thu, 12 Apr 2007 06:43:44 GMT

no i tried it ..it got activated..

Re: table without primary key

Former Member — Thu, 12 Apr 2007 06:45:04 GMT

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

Re: table without primary key

Former Member — Thu, 12 Apr 2007 07:04:31 GMT

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 ..

Re: table without primary key

former_member873340 — Thu, 12 Apr 2007 07:10:31 GMT

hey its not possible....

surely it will throw an error.....

i am saying u dont use adjust and activate

Re: table without primary key

Former Member — Thu, 12 Apr 2007 07:35:42 GMT

Re: table without primary key

Former Member — Sun, 15 Apr 2007 07:52:51 GMT

Dude pls check it once again...

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

sunny

Re: table without primary key

Former Member — Sun, 15 Apr 2007 08:52:23 GMT

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.