Database Table Management - Viewing Table Details

Overview

Version

Application Scenario

There was no dedicated function in FineDataLink for you to check whether the data processing results met expectations. You could only query data using Parameter Assignment, Data Synchronization, or third-party database management tools.

FineDataLink provides a Database Table Management function from V4.1.6.1 to address the aforementioned issues.

Function Description

The Database Table Management function is described below.

• For databases that support SQL statements, you can write SQL statements to query and modify tables.

• You can view data and structures of tables, modify table names and descriptions, clear/delete/duplicate tables, and so on.

Prerequisite

Note:

Both conditions must be met to use the Database Table Management function.

• For FineDataLink of V 4.1.9.2 and later versions, you must have registered the Database Table Management function point. For details, see Function Point Limit.

• You must have permission to use the Database Table Management function. For details, see Data Platform Use Permission.

Function Entry

1. Independently deployed projects: Choose Data Management > Database Table Management, as shown in the following figure.

2. Projects integrated with other FanRuan applications:

• For FineDataLink of versions earlier than V4.1.9.2:

In the FineDataLink project integrated with a FineBI project, choose Data Center > Database Table Management to use this function.

In the FineDataLink project integrated with a FineReport project, this function and Data Development are located in the Data Center module.

• This function in FineDataLink of V4.1.9.2 and later versions has been hidden.

Function Description

Note:

Viewing objects within databases, such as stored procedures and functions, is not supported currently.

Page Overview

After selecting a configured data connection on which you have the Use permission, you can view the databases/schemas and tables/views related to it and search for databases/tables/views, as shown in the following figure.

The number of files within the corresponding directory is displayed on the right side of the folder/database/debugging script directory, as shown in the following figure.

Data Source and Data Connection

For details about data sources supported by Database Table Management, see Data Sources Supported by Database Table Management.

After selecting a configured data connection on which you have the Use permission, you can perform operations on tables associated with the data connection.

Search and Refresh Operations

No.	Description
1	This function has been available since V4.2.1.1. You can search for folders, data connections, and more, and limit the search scope. However, the search for child files is only supported within expanded directories.
2	You can click the Refresh button/icon to refresh the selected table or view to view the latest table structure and data.
3	You can search fields by field name, as shown in the following figure.
4	A refresh button is added to the right of the data connection/database/table/schema/view/ debugging script directory to support manual data refreshing, where the refresh scope is subject to the button location.

Table Data, Table Structure, and Source SQL Statement Tabs

1. Select a table or view, and you can view table data and the table structure, as shown in the following figure. You can open multiple tables simultaneously.

Note:

From V4.1.9.2, FineDataLink supports paginated data viewing, where you can set the number of records per page.

2. From V4.1.9.2, you can view the view creation statements in FineDataLink, as shown in the following figure.

Note that:

• You can view the source SQL statement but cannot modify it.

• Databases that support source SQL statement viewing include MySQL, Oracle, SQL Server, PostgreSQL, SQLite, TiDB, DM, KingBase, GaussDB, Greenplum, Doris, StarRocks, GBase 8a, YMatrix, and PolarDB PostgreSQL.

More Operations

1. After selecting a table and clicking the More button, you can choose to modify the table name and description, clear/delete/ duplicate the table, and generate the corresponding SQL statement, as shown in the following figure.

The following table describes some buttons.

From V4.2.0.3, the statement to be executed will be displayed after you click Clear Table or Delete Table.

2. After you select a view and click the More button, you can choose to modify the view name and description, delete/duplicate the view, and generate the corresponding SQL statement, as shown in the following figure.

The following table describes some buttons.

Table Type Display

From V4.2.0.3, you can view the type of Doris and StarRocks database tables in Database Table Management, as shown in the following figure.