HoloWeb provides the table management feature. You can use this feature to delete tables and view historical table deletion records in a visualized manner. This simplifies your operations. This topic describes how to manage tables and view historical table deletion records in a visualized manner.
Limits
A superuser can view and manage all tables. Common users can view and manage only tables on which the required permissions are granted to them.
A superuser can view the historical deletion records of all tables. Common users can view the historical deletion records of only tables that are deleted by themselves. For more information about Hologres permissions, see Overview.
You can view the deletion records of only tables that were deleted within the last month.
Manage tables
Go to the HoloWeb console. For more information, see HoloWeb quick start.
In the HoloWeb console, click Diagnostics and Optimization in the top navigation bar.
In the left-side navigation pane of the Diagnostics and Optimization page, click Table Management.
On the Table Management tab, configure the parameters that are described in the following table.
Parameter
Required
Description
Instance
Yes
The name of the instance in which the tables that you want to manage reside. The logon instance is selected by default.
Database
Yes
The name of the database in which the tables that you want to manage reside. The logon database is selected by default.
Schema
Yes
The name of the schema in which the tables that you want to manage reside.
Type
Yes
The type of the tables that you want to manage. Valid values:
Tables
Parent Partitioned Table
Foreign Tables
Views
Materialized View
Table Name
No
The name of the table that you want to manage. Fuzzy search is supported.
List Limit
Yes
The maximum number of rows that can be displayed in the list. Maximum value: 2000.
Click Query. A list of tables that meet the filter conditions is displayed.
Find the table that you want to delete and click Delete in the Operation column. You can also select multiple tables and click Batch Delete to delete multiple tables at a time.
View historical table deletion records
Go to the HoloWeb console. For more information, see HoloWeb quick start.
In the HoloWeb console, click Diagnostics and Optimization in the top navigation bar.
In the left-side navigation pane of the Diagnostics and Optimization page, click Table Management.
On the Table Management page, click the Historical Deletion Records tab.
On the Historical Deletion Records tab, configure the parameters that are described in the following table.
Parameter
Required
Description
Instance
Yes
The name of the instance in which you want to view historical table deletion records. The logon instance is selected by default.
Database
Yes
The name of the database in which you want to view historical table deletion records. The logon database is selected by default.
Table Name
No
The name of the table whose historical deletion record you want to view. Fuzzy search is supported.
Time
Yes
The time range during which tables were deleted.
NoteYou can view records of only tables that were deleted within the last month.
Click Query. A list of table deletion records is displayed.
