Help Center> Data Warehouse Service> Tool Guide> Data Studio - Integrated Database Development Tool> Tables (GaussDB A)> Managing Table> Overview
View PDF

Overview

This section describes how to manage tables effectively.

  • You need to fill all the mandatory parameters, that are marked with asterisks (*) to complete the operation successfully.
  • Refreshing is the only operation supported for foreign table.

After creating the table, you can perform operations on the existing table. Right-click the selected table and select the required operation.

Context Menu

Additional options for table operations are available in the table context menu.

The context menu options available for table operations are:

Table 1 Table context menu options

Option

Description

View Table Data

Opens the table data information. Refer to Viewing Table Data

Edit Table Data

Opens the edit table data window. Refer to Editing Table Data

Reindex Table

Performs reindexing a table operation. Refer to Reindexing a Table

Analyze Table

Analyzes a table. Refer to Analyzing a Table

Truncate Table

Truncates table data. Refer to Truncating a Table

Vacuum Table

Vacuums table data. Refer to Vacuuming a Table

Set table Description

Sets the table description for the table. Refer to Setting the Table Description

Set Tablespace

Sets the tablespace for the table. Refer to Setting the Tablespace

Set Schema

Sets the schema for the table. Refer to Setting the Schema

Export Table Data

Exports the table data. Refer to Exporting Table Data

Import Table Data

Imports the table data. Refer to Importing Table Data

Show DDL

Shows the DDL of the table. Refer to Showing DDL

Export DDL

Exports the DDL of the table. Refer to Exporting Table DDL

Export DDL and Data

Exports the DDL and data of the table. Refer to Exporting Table DDL and Data

Rename Table

Renames the table. Refer to Renaming a Table

Drop Table

Drops (deletes) the table. Refer to Dropping a Table

Properties

Displays the properties of the table. Refer to Viewing Table Properties

Grant/Revoke

Grants/Revokes object permissions. For details, see Grant/Revoke Privilege

Refresh

Refreshes a table
Parent topic: Managing Table