All Products
Search
Document Center

Hologres:Manage a schema

Last Updated:Apr 24, 2023

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

Prerequisites

You have logged on to a Hologres instance. For more information, see Log on to an instance.

Create a schema

  1. Log on to the Hologres console.
  2. In the top navigation bar, select a region from the drop-down list. Region
  3. In the left-side navigation pane of the Hologres console, click Go to HoloWeb to go to the HoloWeb console. Go to HoloWeb
  4. In the HoloWeb console, find the left-side Instances Connected list on the Metadata Management tab. Click the instance that you want to manage. Log on to the database that you want to manage, right-click the database, and then select Create Schema. Schema
  5. In the New Schema dialog box, set the Schema name parameter and click OK. By default, the names of the current instance and database are entered in the Instance Name and Database Name fields. You do not need to modify the settings. Create a schema
    The created schema is displayed under the current database in the left-side Instances Connected list.

Manage a schema

To manage a schema, you can refresh information, edit or delete the schema, create an internal table, create a foreign table, or create multiple foreign tables at a time.

  1. Go to the HoloWeb console. On the Metadata Management tab, find the left-side Instances Connected list. All the connected instances are displayed.
  2. Click the instance that you want to manage and click the database that you want to manage. All the created schemas are displayed.
    Note After you log on to a database, a schema named public is automatically created.
  3. Right-click the schema that you want to manage and manage the schema based on your business requirements.
    You can perform the following operations on a schema:
    • Refresh information

      After you modify the schema, refresh the information about the schema.

    • Edit a schema

      Right-click the schema and select Edit Schema. You can modify only the Schema name parameter.

    • Create an internal table, create a foreign table, or create multiple foreign tables at a time

      Right-click the schema and select the type of table that you want to create. On the tab that appears, set the parameters as required. For more information about how to configure each type of table, see the topics of MaxCompute acceleration.

    • Create a view

      Right-click the schema and select Create View. On the Create View page, set the parameters. For more information, see Manage a view.

    • Delete a schema

      Right-click the schema and select Delete Schema. In the Delete mode message, click OK.