topic Re: data dictionary in Application Development and Automation Discussions

data dictionary

Former Member — Sun, 13 Jul 2008 16:13:10 GMT

hi,

i have created a table with 2 primary key and 2 non primary key in developement server.n i release my object also.in production server..

now i wanted to creake one primary key and one non primary key in developement server. Is it possible?? what will be the effect??

Re: data dictionary

Former Member — Sun, 13 Jul 2008 17:39:10 GMT

it is possible , u need change the table and do database utility.

only thing is u will have some data loss for the records .

example:

if ur records r

1 1 a b

1 2 b c

2 1 c d

hear first 2 fields r key fields but u want to chnage the data base table to one key field than when u do data base utility u will loss 2 record which has 1 with same key values which is not valid.

Re: data dictionary

Former Member — Sun, 13 Jul 2008 17:53:17 GMT

I agree with Kumar. In case if you happen to face difficulty in generating or activating the DB table use se14 to adjust and activate the DB table

Re: data dictionary

Former Member — Sun, 13 Jul 2008 18:59:52 GMT

Hi Prasad,

It is possible to change.But u do not have permissions to change that table.Because u don't have permissions to change the table once it can move to DEV system.

Regards,

Kiran Kumar G.A

Re: data dictionary

Former Member — Mon, 14 Jul 2008 02:33:59 GMT

Hi,

Of course you can change it. But the same as they mentioned, data will be lost if the field's attribute has been changed.

why do you want to do like that?

Regards,

Chris