Viewing Schemas

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.
4. On the displayed page, click the name of the target schema or click Manage in the Operation column.
   • On the displayed page, view information about logical tables of the current schema.

     You can view the table name, type, database sharding key, database sharding algorithm, number of shards, table sharding key, table sharding algorithm, number of table shards, auto-increment field, start value for auto-increment field, auto-increment step, status, primary key, creation time, update time, and global secondary index of a logical table.

     Step for Auto-Increment indicates the auto-increment cache value of a global sequence, instead of the number generated for the auto-increment field each time a new record is inserted.

     You can click View Table Structure in the Operation column to view the SQL statement used for creating this table.

   • 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.