Schemas

Create a schema

1. Log on to the Hologres management console.

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

3. Click Go to HoloWeb to open the HoloWeb developer page.

4. On the HoloWeb development page, find the Instances connected list on the Metadata Management tab. Right-click the target database and select Log On to Database.

5. In the Log On to Database dialog box, click OK. Then, in the instance tree on the left, right-click the target database and select Create Schema.

6. Enter a Schema Name and click OK. The Instance Name and Database Name fields are automatically populated and cannot be modified. The new schema appears in the list under the connected database.

Manage schemas

You can perform operations on a schema, such as refresh, edit, create an internal table, create a MaxCompute external table, create a Data Lake Formation (DLF) external table, create a view, and delete the schema.

1. On the HoloWeb development page, go to the Metadata Management tab. The Instances connected list displays the connected instances.

2. Click the target instance and then the target database to view all created schemas.

   Note

   After you log on to a database, a schema named public is created by default.

3. Right-click the target schema to perform management operations.

   • Refresh

     Refreshes the schema to show the latest content changes.

   • Edit Schema

     Right-click the target schema and select Edit Schema. You can modify only the Schema Name.

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

     Right-click the target schema and select the desired table type. Configure parameters in the right pane. For more information about how to configure different table types, see Accelerate MaxCompute queries.

   • Create View

     Right-click the target schema and select Create View. On the Create View page, configure the parameters. For more information, see Views.

   • Delete Schema

     Right-click the target schema and select Delete Schema. Review the schema information, and then click OK to delete the schema.

Related documentation

You can also use SQL statements to create, modify, and delete schemas. For more information, see the following topics:

• CREATE SCHEMA

• ALTER SCHEMA

• DROP SCHEMA