Updated on 2025-04-16 GMT+08:00

Rolling Back the Table Structure

After the database table is initialized, the system modifies the table structure. You are advised to roll back the table structure if the table needs to restored to the original state.

Scenario: After the database table is initialized and before encryption, you need to manually roll back the table structure to the original state.

Figure 1 Initializing a table

Procedure

  1. Log in to a database encryption and access control instance as the sysadmin user.
  2. In the navigation tree on the left, choose Data Encryption > Rollback Table Structure.
  3. Click Data Source and select the asset name and pattern name, as shown in Figure 2.

    Figure 2 Selecting a mode

  4. In the list, select a database table and click Check Associate Task.
  5. Click Restore Table Structure.
  6. Click Restore Column.

    After all tables in the data asset are rolled back, you can go to the data source management page and perform operations such as deleting the data asset.