AnsweredAssumed Answered

Changing Attribute Data-Types via SQL script

Question asked by NickMiller on Feb 14, 2011
Latest reply on Feb 15, 2011 by another_martink

Quick question for the group.

Is it possible to update an object attribute by running a script at the database level?

For example, you create a new attribute used to record comments from users (data type = 'String'). You publish the new attribute and users populate this field. Later you realise that this data type is too small and need to change it to 'Large String'.

Can a SQL script be run to change the data type (thus extending the field size?) without losing the current data? If not, how would you accomplish this task?

Many thanks,