Help Center/ Distributed Database Middleware/ User Guide/ Schema Management/ Viewing Schemas and Logical Table Information
Updated on 2024-07-30 GMT+08:00

Viewing Schemas and Logical Table Information

You can view schemas and logical table information of a DDM instance on the DDM console without using any code.

Precautions

  • Table structures of a schema that fails to be created cannot be viewed.
  • The schema is in the Running or Configuring shards state.

Procedure

  1. Log in to the DDM console.
  2. In the instance list, locate the required instance and click its name.
  3. On the displayed page, in the navigation pane on the left, choose Schemas.

    Figure 1 Schema list

    If you want to view the disk size of a schema, contact customer services.

    • Only schemas in the running state can be viewed.
    • The disk size is only an estimate.
    • Querying the disk size of a schema affects the performance of a DDM instance.

  4. On the displayed page, click the name of the target schema or click Manage in the Operation column.

    • On the Associated DB Instances page, view instance information of the current schema.
    • On the Connection Address tab page, obtain CLI and JDBC connection addresses of the DDM instance.

      For details, see Log In to the DDM Schema.