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
Hi,

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,
Nock

Outcomes