How do you rename a custom attribute?

最新推荐文章于 2025-10-20 09:37:39 发布

原创最新推荐文章于 2025-10-20 09:37:39 发布 · 168 阅读

0 ·

CC 4.0 BY-SA版权

Documentum 专栏收录该内容

14 篇文章

订阅专栏

本文详细介绍了如何在数据库中重命名自定义属性，包括创建新属性、迁移原有值及删除旧属性的步骤。通过SQL命令实现数据迁移，确保数据一致性。

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]