Good morning,
I have several columns in a table that have data type of numeric.
Is there a script that I can run it to change the columns instead of manually change the columns one by one?
Thanks,
Canh
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?"
Canh
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?"
Canh
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.