How do i change the field of primary key in a record ?

Question

I gave an field as an primary key by mistake and now i want to give the primary key field to another field. Can anyone help me with that, iam new to appian.

Teja Kunchala · Accepted Answer

Hi skzahed_09 If you have created a new field JOB_POSTING_ID after there are some entries inserted in the table, then while creating the field keep the default value as NULL(If not null then 0's will be stored to all the fields and above error will be shown) and apply the auto increment (Click on check box).

Teja Kunchala · Answer

Did you add JOB_POSTING_ID as a new field or changing the old field as a primary key? I can see that the field is not auto increment If it is then in Extra column we will get it as AUOT_INCEMENT Like this. So make it auto increment then your error will be resolved.

Teja Kunchala · Answer

Click on change option from structure and click on check box under A.I (9th column before comments).

aditya007 · Answer

If your record was created from a database table, you need to update the primary key in the database table. After that, perform a remapping of the record source in Appian. Once the remapping is complete, the changes will be reflected in the record type

Harsha Sharma · Answer

FIrst you need to make the changes in your database table by dropping the primary key there and applying it to to the intended column. Once done in database you can update the mappings in the record.

Konduru Chaitanya · Answer

Hello skzahed_09 
 Please refer this basics of SQL which would help you achieve. www.w3schools.com/.../sql_primarykey.ASP

How do i change the field of primary key in a record ?

Top Replies