All Products
Search
Document Center

Batch table operations

Last Updated: Jun 08, 2019

This section describes how to perform batch operations on tables.

Prerequisites

You have access permissions to DMS and you have logged on to the DMS console.

Procedure

  1. Choose a target database and click Log On to Database.

  2. In the left-side table directory tree, right-click a table and select Batch Operations.

    Batch Operations

    Notes

    • No.1 : The operations menu.

    • No.2: Click Drop Batch Tables. The Drop Batch Tables window is displayed.

    • No.3: Click More Operations to select operations. You can clear data, drop tables, maintain tables, and edit table names (prefix and suffix).

  3. Click Drop Batch Tables. The Drop Batch Tables window is displayed.

    The Drop Batch Tables window

    1. Select the target tables.

    2. Click OK. DMS prompts you to confirm whether you want to drop the selected tables.

    3. Click Yes. DMS drops the selected tables.

  4. Click More Operations. The More Operations window is displayed.

    1. Select the target tables.

    2. Click the target operation button above. DMS prompts you to confirm whether you want to execute the operation to selected tables.

    3. Click Yes. DMS executes the target operation.Notes

Other batch operations such as truncating tables, batch deletion, maintaining tables, and modifying table name prefixes or suffixes are similar to dropping tables.