Updated on 2023-03-28 GMT+08:00

Database Management

Function Overview

Table 1 Functions

Function

Description

Database information

Displays the name, IP address, character set, and SQL window of the current database.

Schema list

Allows you to manage data with different schemas in a database.

Object list

Consists of five types of objects (tables, views, stored procedures, triggers, and functions).

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.

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, triggers, and functions of Microsoft SQL Server databases. The main operations include creating, querying, and modifying objects.