Overview

This section describes how to manage tables efficiently.

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.

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.