AnalyticDB for MySQL provides visual management for databases and tables in a cluster through the console.
Prerequisites
An AnalyticDB for MySQL Enterprise Edition, Basic Edition, or Data Lakehouse Edition cluster is created.
A RAM user is attached to a database account. For more information, see Attach or detach a RAM user to or from a database account.
Usage notes
Only information about databases, tables, and views can be displayed.
Data from the Information_schema system database and data within AnalyticDB for MySQL cannot be displayed.
Procedure
Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. Find the cluster that you want to manage and click the cluster ID.
In the navigation pane on the left, click .
On the Database List tab, you can view information about databases.
Ordinal number
Area
Description
①
Search box
Allows you to perform a fuzzy search by database name.
②
Database list
Displays the Database Name, Creation Time, and Update Time, and lets you sort databases by Database Name, Creation Time, or Update Time.
Click the name of the destination database to view information about Tables and Views.
The Tables tab
Ordinal number
Area
Description
①
Search box
Allows you to perform a fuzzy search by table name.
Allows you to search for tables by table type (foreign table, replicated table, or fact table).
Allows you to perform a fuzzy search by description.
②
Database list
Displays the Database, Table Name, Table Type, Storage Size, Description, Creation Time, and Update Time, and lets you sort tables by Table Name, Storage Size, Creation Time, or Update Time.
Click the name of the target Table to view its details.
Ordinal number
Area
Description
①
Table information
Displays the Database, Table Name, Table Type, and Description.
②
Go to SQL Development
Click this button to go to the SQL Development page. For more information about SQL Development, see SQL development.
③
Data Preview
Displays the data of the table. By default, the first 10 rows of data in the table are displayed.
④
DDL Statement
Displays the SQL statement that is used to create the table. The SQL statement is read-only.
⑤
Search box
Allows you to perform a fuzzy search by field name.
⑥
Basic Information
Displays the Field Name, Data Type, Nullable, Primary Key, Distribution Key, Partition Key, and Description. These parameters are read-only.
NoteThe displayed information may vary based on the table type.
The Views tab
Ordinal number
Area
Description
①
Search box
Allows you to perform a fuzzy search by view name.
Allows you to search for views by view type (standard view or materialized view).
Allows you to perform a fuzzy search by view owner.
②
Database list
Displays the Database, View Name, View Type, View Owner, Creation Time, and Update Time, and lets you sort views by View Name, Creation Time, or Update Time.
Click the name of the target View to view the SQL statement used to create it.
Ordinal number
Area
Description
①
View information
Displays the Database, View Name, View Type, and Description.
②
Go to SQL Development
Click this button to go to the SQL Development page. For more information about SQL Development, see SQL development.
③
DDL Statement
Displays the SQL statement that is used to create the view. The SQL statement is read-only.