I would like to clarity on my question that I meant "is there a script that I can run it to change the data type from numeric to character instead of manually change the columns one by one?"
I would like to clarity on my question that I meant "is there a script that I can run it to change the data type from numeric to character instead of manually change the columns one by one?"
You could write a script to do that but it's not necessary. Select the columns you want to change and choose Cols->Standardize Attributes. That will let you change data type, modeling type, column properties, etc. for many columns at once.