Overview

This section describes how to manage tables efficiently.

Note

  • You need to configure all mandatory parameters to complete the operation. Mandatory parameters are marked with asterisks (*).

  • 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

Menu Item

Description

View Table Data

Opens the table data information. For details, see Viewing Table Data.

Edit Table Data

Opens the window for editing table data. For details, see Editing Table Data.

Reindex Table

Re-creates the table index. For details, see Reindexing a Table.

Analyze Table

Analyzes a table. For details, see Analyzing a Table.

Truncate Table

Truncates table data. For details, see Truncating a Table.

Vacuum Table

Vacuums table data. For details, see Vacuuming a Table.

Set Table Description

Sets table description. For details, see Setting the Table Description.

Set Schema

Sets the schema of a table. For details, see Setting the Schema.

Export Table Data

Exports table data. For details, see Exporting Table Data.

Import Table Data

Imports table data. For details, see Importing Table Data.

Show DDL

Shows the DDL of a table. For details, see Show DDL.

Export DDL

Exports Table DDL. For details, see Exporting Table DDL.

Export DDL and Data

Exports DDL and table data. For details, see Exporting Table DDL and Data.

Rename Database

Renames a table. For details, see Renaming a Table.

Drop Table

Drops (deletes) a table. For details, see Dropping a Table.

Properties

Shows table properties. For details, see Viewing Table Properties.

Grant/Revoke

Grants or revokes permissions. For details, see Grant/Revoke Privilege.

Refresh

Refreshes a table.