HoloWeb provides a table management feature that lets you delete tables and view deletion records from a visual interface to simplify your operations. This topic describes how to manage tables and view historical table deletion records.
Limits
-
A superuser can view and manage all tables. A regular user can view and manage only the tables for which they have permissions.
-
A superuser can view all table deletion records. A regular user can only view their own table deletion records. For more information about Hologres permissions, see Hologres permission model.
-
Table deletion records are available for the last month only.
Access the feature
Log on to the Hologres management console.
In the top navigation bar, select a region.
Click Go to HoloWeb to open the HoloWeb developer page.
-
In the top menu bar of the HoloWeb developer page, click Diagnostics and Optimization.
Manage tables
Follow the steps in Access the feature to go to the Diagnostics and Optimization page. Then, perform the following steps.
-
On the Diagnostics and Optimization page, click in the navigation pane on the left.
-
On the Table Management page, configure the following filter parameters.
Parameter
Required
Description
Instance Name
Yes
The name of the instance where you want to manage tables. The current instance is selected by default.
Database
Yes
The name of the database where you want to manage tables. The current database is selected by default.
Schema
Yes
The name of the schema where you want to manage tables.
Type
Yes
The type of table to manage. Valid values:
-
Table
-
Partitioned parent table
-
Appearance
-
View
-
Materialized view
Table Name
No
The name of the table to find and manage. Fuzzy search is supported.
Number of Rows to Query
Yes
The number of rows to return in the list. A maximum of 2,000 rows can be displayed.
-
-
Click Search to view the list of tables.
In the Actions column of a table, click Delete to delete the table. You can also select multiple tables and click Batch Remove to delete them in a batch.
Historical table deletion records
Follow the steps in Access the feature to go to the Diagnostics and Optimization page. Then, perform the following steps.
-
On the Diagnostics and Optimization page, click in the navigation pane on the left.
-
On the Table Management page, click the Historical Deletion Records tab.
-
On the Historical Deletion Records tab, configure the following filter parameters.
Parameter
Required
Description
Instance Name
Yes
The name of the instance whose historical table deletion records you want to view. The current instance is selected by default.
Database
Yes
The name of the database whose historical table deletion records you want to view. The current database is selected by default.
Table Name
No
The name of the table to find related deletion records. Fuzzy search is supported.
Time Range
Yes
The time range during which the historical table deletion records were collected.
NoteTable deletion records are available for the last month only.
-
Click Search to view the corresponding deletion records.
