Can I change table field from integer to string?

Akki1
Tera Contributor

I have a field which is type integer now I want to change to string can i do that? because when i try to change no other options are available other than integer

1 ACCEPTED SOLUTION

Pavankumar_1
Mega Patron

Hi @Akki1 ,

if integer field has any data on the table records you need to clear/ make those values to blank then you can change to string type.

If you want data as well take XML export and clear those integer values and after changing to string you can import.

If it helps please click Accept as Solution/hit the Thumb Icon.
ServiceNow Community MVP 2024.
Thanks,
Pavankumar

View solution in original post

1 REPLY 1

Pavankumar_1
Mega Patron

Hi @Akki1 ,

if integer field has any data on the table records you need to clear/ make those values to blank then you can change to string type.

If you want data as well take XML export and clear those integer values and after changing to string you can import.

If it helps please click Accept as Solution/hit the Thumb Icon.
ServiceNow Community MVP 2024.
Thanks,
Pavankumar