cmdb_ci type change

[Vaibhav Ramteke]

Hello,

In dev original cmdb_ci type change reference to choice i want restore as reference there is any way to do because when i tried its not restore. 

[Dr Atul G- LNG]

https://www.servicenow.com/community/developer-blog/how-to-fix-a-reference-to-the-choice-sys-choice-...

In ServiceNow, it is highly recommended to never change an existing field's type directly (e.g., Reference to Choice). This breaks existing data relationships. Instead, create a new Choice field, map the existing data over, and retire the old field. [1]

[Tanushree Maiti]

Hi @Vaibhav Ramteke 

• How to fix a reference to the Choice [sys_choice] table
• KB0815336 Reference qualifier not working for cmdb_ci field on change_request form 

[RaghavendraGund]

Hello Vaibhav
No automatic way—you'll need to manually revert it in the Dictionary Entry.
Go to System Definition > Tables & Columns → find the cmdb_ci Dictionary Entry and change the Type back to "Reference." Then restore the Reference Specification (target table, reference qualifier, etc.).
Important: Before reverting, check if any records have data in that field while it was a Choice type. If yes, you'll need to migrate those values to valid CI sys_ids first, otherwise the references will break.
ServiceNow doesn't version field type changes at the Dictionary level, so there's no "undo"—it's manual reconfiguration all the way.

Regards
RaghavendraGunda