Updated on 2022-08-16 GMT+08:00

ALTER FOREIGN TABLE (for GDS)

Function

ALTER FOREIGN TABLE 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);