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

data dictionary

Former Member
0 Likes
584

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
564

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.

4 REPLIES 4
Read only

Former Member
0 Likes
565

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.

Read only

Former Member
0 Likes
564

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

Read only

Former Member
0 Likes
564

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

Read only

Former Member
0 Likes
564

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