Updated on 2024-08-29 GMT+08:00

Creating a Schema

After a database is created, you need to create a schema because database operations cannot be performed in system schemas. This section describes how to create a schema and execute SQL statements.

Procedure

  1. Log in to the DAS console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
  6. In the database list of the Home page, locate the database where you want to create a schema and click Manage in the Operation column.

    Figure 1 Database management

  7. Click Create Schema. On the displayed page, enter a schema name.

    Figure 2 Creating a schema

  8. Click OK. The schema you created appears in the schema list.