Help Center/ GaussDB(DWS)/ SQL Syntax Reference (9.1.0.x)/ DDL Syntax/ ALTER FOREIGN TABLE (GDS Import and Export)
Updated on 2024-09-30 GMT+08:00
View PDF

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;
  • Set the row-level access control switch (supported by cluster versions 9.1.0 and later). 
    ALTER FOREIGN TABLE [ IF EXISTS ] tablename
        ENABLE | DISABLE | FORCE | NO FORCE ROW LEVEL SECURITY

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

Parent topic: DDL Syntax