How do you rename a custom attribute?

The key point of this operation is keep the values stored in this attribute.

 

You can rename the custom attribute using the following steps:

- Create the custom attribute with the new name

ALTER TYPE type_name ADD attribute_def {,attribute_def}[PUBLISH]

- Copy the values from old custom attribute to new custom attribute in SQL statements

After you create the attribute you should try the following statement in SQL:

SQL> update <custom type> set <new custom attribute>=<old custom attribute>;

SQL> commit;

Here is an example:

SQL> update bayaca_s set content_language=language1;

3 rows updated.

SQL> commit;

- Drop old custom attribute

ALTER TYPE type_name DROP attribute_name {,attribute_name}[PUBLISH]