Database Management
Function Overview
Figure 1 Database Management
Function | Description |
|---|---|
Sidebar | Consists of six types of objects (tables, views, stored procedures, events, triggers, and functions). |
Database information | Displays the name, IP address, character set, SQL window, and data dictionary of the current database. |
Metadata Collection | Allows DAS to automatically collects only the data such as database names, table names, and field names in an instance (user data in your tables is not included). NOTE: If there are too many tables, the system will not collect the metadata and display the table list to mitigate the impact on database performance. |
SQL tuning | Diagnoses SQL statements and SQL files. |
List details | Displays the operation area for each type of object. |
You can go to the Database Management page in either of the following ways:
- Choose Database Management on the top menu bar.
- In the database list of the Home page, locate the target database and click Manage in the Operation column.
Object List
You can manage tables, views, stored procedures, events, triggers, and functions of the MySQL DB instances. The main operations include creating, querying, and modifying objects.
- For details on how to manage tables, see Table Management.
- For details on how to manage views, see View Management.
- For details on how to manage events, see Event Management.
- For details on how to manage store procedures, see Stored Procedure Management.
- For details on how to manage functions, see Function Management.
- For details on how to manage triggers, see Trigger Management.
- Function Overview
- Object List