Foreign Table#

Create#

Right-click on the foreign table in the database object tree and select New. Edit the foreign table statement and click OK to create the foreign table.

Edit#

Right-click on the foreign table in the database object tree and select Edit. Edit the foreign table statement and click OK to modify the foreign table.

Rename#

Right-click on the foreign table in the database object tree and select Rename. Enter the new foreign table name and click OK to complete the renaming.

Drop#

Right-click on the foreign table in the database object tree and select Drop. A confirmation pop-up will appear. Click OK to Drop the foreign table.

Script#

View DDL#

Right-click on the foreign table in the database object tree and select Script -> View DDL. You can view and copy the DDL statement in the pop-up box.

Generate Select#

Right-click on the foreign table in the database object tree and select Script -> Generate Select.... View the statement in the pop-up box.