Hologres:Manage schemas

Create a schema

1. Log on to the Hologres console.

2. In the top navigation bar, select a region.

3. In the left navigation pane, click Go to HoloWeb.

4. In HoloWeb, select the Metadata Management tab in the top navigation menu. In the left Instance Management panel, right-click the destination database and select Log On To Database.

5. In the Log On To Database dialog box, click OK. Then, right-click the destination database and select Create Schema.

6. In the Create Schema dialog, set Schema Name and click Confirm. Instance Name and Database Name are automatically populated with the names of the current instance and database. You do not need to change them. The created schema appears in the list under the connected database.

Manage a schema

Refresh, edit, and delete a schema. Create an internal table, a MaxCompute foreign table, a DLF foreign table, or a view.

1. In HoloWeb, select the Metadata Management tab in the top navigation bar.

2. In the Instance Management panel, select a connected database to list schemas under it.

   Note

   After you log on to a database, the public schema is automatically created.

3. Right-click the target schema to manage it.

   You can perform the following operations:

   • Refresh

     After modifying a schema, refresh it to sync the changes.

   • Edit Schema

     You can only change schema name.

   • Create Internal Table, Create MaxCompute External Table, and Create DLF External Table

     Configure the parameters on the page that appears. For more information, see Accelerate queries for MaxCompute tables.

   • Create View

     On the Create View page, configure the view. For more information, see Manage views.

   • Delete Schema

     In the dialog box, confirm the schema information and click Confirm.

References

Use SQL statements to create, modify, and drop schemas:

• CREATE SCHEMA

• ALTER SCHEMA

• DROP SCHEMA