HoloWeb's table management feature lets you search, delete, and audit table deletion history through a visual interface — no SQL required.
Limitations
| Limitation | Details |
|---|---|
| Table management scope | Superusers can view and manage all tables. Regular users can only view and manage tables for which they have permissions. |
| Deletion record scope | Superusers can view all deletion records. Regular users can only view their own deletion records. |
| Deletion record retention | Records are retained for the last month only. |
For details about Hologres permissions, see Hologres permission model.
Prerequisites
Before you begin, make sure that you have:
Access to the Hologres Management Console
The required permissions to manage or view the target tables
Get to table management
Log on to the Hologres Management Console.
In the navigation pane on the left of the top menu bar, select the target region.
Click Go to HoloWeb.
In the HoloWeb top menu bar, click Diagnostics and Optimization.
In the left navigation pane, click Table Metadata Management > Table Management.
Delete tables
On the Table Management page, set the following filter parameters and click Search.
Parameter Required Description Instance Name Yes The instance whose tables you want to manage. Defaults to the current instance. Database Yes The database whose tables you want to manage. Defaults to the current database. Schema Yes The schema whose tables you want to manage. Type Yes The type of object to list. Valid values: Table, Partitioned parent table, Appearance, View, Materialized view. Table Name No A table name or partial name. Fuzzy search is supported. Number of rows to query Yes The number of rows to return. Maximum: 2,000. In the Actions column of the table you want to delete, click Delete. To delete multiple tables at once, select the checkboxes next to the target tables and click Batch Remove.
View deletion records
Use the Historical Deletion Records tab to audit which tables were deleted, by whom, and when. Records are available for the last month only.
On the Table Management page, click the Historical Deletion Records tab.
Set the following filter parameters and click Search.
Parameter Required Description Instance Name Yes The instance whose deletion records you want to view. Defaults to the current instance. Database Yes The database whose deletion records you want to view. Defaults to the current database. Table Name No A table name or partial name to filter records. Fuzzy search is supported. Time Range Yes The time window to search within. Records from the last month only are available. 