‎2008 Jul 13 5:13 PM
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??
‎2008 Jul 13 6:39 PM
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.
‎2008 Jul 13 6:39 PM
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.
‎2008 Jul 13 6:53 PM
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
‎2008 Jul 13 7:59 PM
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
‎2008 Jul 14 3:33 AM
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