Prerequisites
• You have viewing or higher permissions to the instance.
• You need to log in to the current instance first.
Procedure
• MySQL Database
1. Log in to DMS.
2. On the left menu bar, click Data Source Management > Instance Metadata to go to the Instance List page.
3. Go to the Operate menu bar of the target instance and click the Database List button to go to the database management page.
4. Go to the Operate menu of the database list and click the Object List button to go to the Object List Management page.
5. Click the Synchronize Metadata button to obtain the real-time metadata information of the database.
• PostgreSQL Database
1. Log in to DMS.
2. On the left menu bar, click Data Source Management > Instance Metadata to go to the Instance List page.
3. Go to the Operate menu bar of the target instance and click the Database List button to go to the database management page.
4. Go to the Operate menu bar of the database list and click Schema List to go to the Schema List Management page.
5. Go to the Operate menu bar of the schema list and click Object List to go to the Object List Management page.
6. Click the Synchronize Metadata button to obtain the real-time metadata information of the database.
• SQLServer Database
1. Log in to DMS.
2. On the left menu bar, click Data Source Management > Instance Metadata to go to the Instance List page.
3. Go to the Operate menu bar of the target instance and click the Database List button to go to the database management page.
4. Go to the Operate menu of the database list and click the Object List button to go to the Object List Management page.
5. Click the Synchronize Metadata button to obtain the real-time metadata information of the database.
• DRDS Database
1. Log in to DMS.
2. On the left menu bar, click Data Source Management > Instance Metadata to go to the Instance List page.
3. Go to the Operate menu bar of the target instance and click the Database List button to go to the database management page.
4. Go to the Operate menu of the database list and click the Object List button to go to the Object List Management page.
5. Click the Synchronize Metadata button to obtain the real-time metadata information of the database.
• MongoDB/DDS Database
1. Log in to DMS.
2. On the left menu bar, click Data Source Management > Instance Metadata to go to the Instance List page.
3. Go to the Operate menu bar of the target instance and click the Database List button to go to the database management page.
4. Go to the Operate menu of the database list and click the Object List button to go to the Object List Management page.
5. Click the Synchronize Metadata button to obtain the real-time metadata information of the database.
The Object List manages the following database objects:
Object | Description |
Table | Supports table operations such as creating, editing, deleting, and more. |
Set | Supports set operations such as creating, deleting, and more. |
View | Supports view operations such as creating, editing, deleting, and more. |
Stored Procedure | Supports stored procedure operations such as creating, editing, deleting, and more. |
Function | Supports function operations such as creating, editing, deleting, and more. |
Trigger | Supports trigger operations such as creating, editing, deleting, and more. |
Event | Supports event operations such as creating, editing, deleting, and more. These operations only apply in the MySQL-series databases. |
Trigger Function | Supports trigger operations such as creating, editing, deleting, and more. These operations only apply in the PostgreSQL-series databases. |
Sequence | Supports trigger operations such as creating, editing, deleting, and more. These operations only apply in the PostgreSQL-series databases. |
Table Management
² Note
This function applies to non-MongoDB/DDS data sources.
Creating a Table
Supports visualized editing of the created table. For details, see Query Window->Querying and Creating/Editing a Table Structure.
Synchronizing Metadata
Refreshes the table metadata for the current database/schema. The following conditions are required for this operation:
• You have logged in to the current instance.
• The user logged in to the database has obtained permission to access the database metadata.
Table Details
Go to the Operate bar of the list and click the Details button to display the details of the selected table, including column information and index information.
• Column Information: Includes the column name, primary key, and other key information.
• Index: Includes the index name, index field, and other key information.
Opening a Table
Go to the Operate bar of the list and click the Open button to open the view information of the table. By default, 20 rows are displayed.
• When you click Open Table, you will be navigated to the DMS Query Window page.
• The Query Window page displays the SELECT statement for the current table,
• automatically executes that SELECT statement, and returns the result set.
Generating DDL
Go to the Operate bar of the list and click the DDL button to generate the DDL information for the table. You can also replicate the generated DDL statements.
• You have logged in to the current instance.
• The user logged in to the database has obtained permission to access the database metadata.
• The current user has permission to access the table.
Deleting a Table
Go to the Operate bar of the list and click the Delete button. After re-confirmation, click the OK button to finish deleting the table.
• You have logged in to the current instance.
• The user logged in to the database has obtained permission to access the database metadata.
• The current user has permission to delete the table.
Creating/Editing a Programmable Object
Supports visualized creating/editing of programmable objects. For details. see Query Window->Creating/Editing a Programmable Object.
Synchronizing Metadata
Refreshes the metadata of the programmable objects for the current database/schema. The following conditions are required for this operation:
• You have logged in to the current instance.
• The user logged in to the database has obtained permission to access the database metadata.
Generating DDL
Go to the Operate bar of the list and click the DDL button to generate the DDL information for the programmable object. You can also replicate the generated DDL statements.
• You have logged in to the current instance.
• The user logged in to the database has obtained permission to access the database metadata.
Deleting a Programmable Object
Go to the Operate bar of the list and click the Delete button. After re-confirmation, click the OK button to finish deleting the programmable object.
• You have logged in to the current instance.
• The user logged in to the database has obtained permission to access the database metadata.
• The current user has permission to delete the programmable object.