This topic describes how to use HoloWeb to create, edit, and delete a schema in Hologres.

Prerequisites

  • An Alibaba Cloud account is created.
  • Real-name verification is completed.
  • A Hologres instance is purchased. For more information, see Purchase a Hologres instance.

Create a schema

  1. Connect the purchased Hologres instance to HoloWeb. For more information, see Manage a connection.
  2. On the HoloWeb page, choose Connection Management > Mode.
    You can also click My connection on the Connection Management page. Click the required connection and then click Database. Right-click the required database and select New mode, or click the database, right-click Schema, and then select New mode.
  3. Set the Connection name, Database name, and Pattern name parameters, and click OK.New mode

Edit a schema

  1. Choose Connection Management > My connection. All the available connections are displayed.
  2. Click the required connection and then click Database. All the created databases are displayed.
  3. Click the required database and then click Schema. All the created schemas are displayed.
    Note After a database is created, a schema named public is automatically created.
  4. Right-click the required schema and select Edit mode.
  5. Change the value of the Pattern name parameter based on your business requirements.Edit mode
    Note In the Edit mode dialog box, you can only change the value of the Pattern name parameter.

Delete a schema

  1. Choose Connection Management > My connection. All the available connections are displayed.
  2. Click the required connection and then click Database. All the created databases are displayed.
  3. Click the required database and then click Schema. All the created schemas are displayed.
  4. Right-click the required schema and select Delete mode.
  5. Click OK.