ALTER FOREIGN TABLE (GDS Import and Export)

Function

Modifies a foreign table.

Precautions

None

Syntax

• Set the attributes of a foreign table.

  1 2	ALTER FOREIGN TABLE [ IF EXISTS ] table_name OPTIONS ( {[ ADD | SET | DROP ] option ['value']}[, ... ]);

• Set a new owner.

  1 2	ALTER FOREIGN TABLE [ IF EXISTS ] tablename OWNER TO new_owner;

Parameter Description

• table_name

  Specifies the name of an existing foreign table to be modified.

  Value range: an existing foreign table name.

• option

  Name of the option to be modified.

  Value range: See Parameter Description in CREATE FOREIGN TABLE.

• value

  Specifies the new value of option.

Examples

Modify the customer_ft attribute of the foreign table. Delete the mode option.

1

ALTER FOREIGN TABLE customer_ft options(drop mode);

Helpful Links

CREATE FOREIGN TABLE (for GDS Import and Export), DROP FOREIGN TABLE