You can use the schema design feature that is provided by Data Management (DMS) to change the schema of a table in a convenient and standardized manner.
Background information
You can use the schema design feature to create tables or change schemas when you develop a project, process a new requirement, or optimize the schema of a table. For example, you can use this feature to add or delete columns or indexes, modify column attributes, or modify index compositions.
This feature is suitable when multiple development environments are involved. For example, you can use this feature to verify a new schema script in a development environment and then publish the script to a production environment with only a few clicks. This feature automatically checks whether the SQL statements for schema changes conform to the R&D specifications during the development process. For example, this feature can be used to ensure that the columns that are used in a production environment are not deleted. This feature allows multiple users to perform collaborative development in the DMS console.
This feature allows you to change the schema of a table as required. The feature ensures that related schemas that are designed based on various R&D specifications or in different environments are consistent and conform to the design specifications. This way, the success rate is improved when the new schema is published to a production environment.