Table management

Limitations

• A superuser can view and manage all tables. A regular user can only view and manage tables they have permission to access.

• A superuser can view all deletion records. A regular user can only view their own deletion records. For more information about Hologres permissions, see Hologres permission model.

• You can only view deletion records from the last month.

Feature access

1. Log on to the Hologres management console.

2. In the top navigation bar, select a region.

3. Click Go to HoloWeb to open the HoloWeb developer page.

4. In the top navigation bar of the HoloWeb page, click Diagnostics and Optimization.

Table management

Go to the Diagnostics and Optimization page as described in Feature access, and then perform the following steps.

1. On the Diagnostics and Optimization page, click Table Metadata Management > Table Management in the navigation pane on the left.

2. On the Table Management page, configure the following filter parameters.

   Parameter	Required	Description
   Instance Name	Yes	The instance that contains the tables to manage. Defaults to the current instance.
   Database	Yes	The database that contains the tables to manage. Defaults to the current database.
   Schema	Yes	The name of the schema that contains the tables to manage.
   Type	Yes	The type of object to manage. You can select one of the following: Table. Partitioned parent table. Foreign table. View. Materialized view.
   Table Name	No	The name of the table to find. Fuzzy search is supported.
   Number of rows to return	Yes	The number of rows to return in the list. Maximum: 2,000.

3. Click Search to view the list of tables that match your filter criteria.

   In the Actions column for a table, click Delete to delete the table. You can also select multiple tables and click Batch Remove.

Deletion history

Go to the Diagnostics and Optimization page as described in Feature access, and then perform the following steps.

1. On the Diagnostics and Optimization page, click Table Metadata Management > Table Management in the navigation pane on the left.

2. On the Table Management page, click the Historical Deletion Records tab.

3. On the Historical Deletion Records tab, configure the following filter parameters.

   Parameter	Required	Description
   Instance Name	Yes	The instance that contains the deletion records to view. Defaults to the current instance.
   Database	Yes	The database that contains the deletion records to view. Defaults to the current database.
   Table Name	No	The name of the table to find records for. Fuzzy search is supported.
   Time Range	Yes	The time range of the deletion records. Note You can only view deletion records from the last month.

4. Click Search to view the deletion records.

   You can filter the records by Instance Name, Database, Table Name (fuzzy search supported), and Time Range. For the time range, you can select quick options such as the last 10 minutes, last hour, or last 7 days. The results table includes columns such as No., Database, Query, Query Id, User Name, and Start Time.