Project Explorer in MaxCompute Studio provides a table schema editor that allows you to manage tables in a visualized manner. This topic describes how to use Project Explorer to create, modify, and delete tables in a visualized manner.

Create a table

  1. In the Project Explorer tool window, right-click Tables & Views under your MaxCompute project, and select Create new table.
  2. In the Create New Table/View dialog box, configure the parameters.
    Create a table
    For more information about how to configure the parameters, see Table operations.
    Note
    You cannot set flags for tables that are created in a visualized manner. The system uses the following flags by default:
    • odps.sql.submit.mode=script
    • odps.sql.type.system.odps2=true
  3. Click Execute. If the SUCCESS message appears, the table is created.

Modify a table

  1. In the Project Explorer tool window, click the drop-down arrow on the left side of Tables & Views under your MaxCompute project. In the table list, right-click the table that you want to modify and select Open table editor.
  2. In the Modify Table dialog box, modify the table.
    You can add columns to the table and change the table name, table comments, table lifecycle, column name, and column description. For more information, see Table operations.Modify a table
  3. Click Execute to apply the modifications.

Delete a table

  1. In the Project Explorer tool window, click the drop-down arrow on the left side of Tables & Views under your MaxCompute project. In the table list, right-click the table that you want to delete, and select Drop table from server.
    Delete a table
  2. In the Confirmation Required message, click OK to delete the table.