ALTER FOREIGN TABLE (for GDS)¶
Function¶
ALTER FOREIGN TABLE modifies a foreign table.
Precautions¶
None
Syntax¶
Set the attributes of a foreign table.
ALTER FOREIGN TABLE [ IF EXISTS ] table_name OPTIONS ( {[ ADD | SET | DROP ] option ['value']}[, ... ]);
Set a new owner.
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.
ALTER FOREIGN TABLE customer_ft options(drop mode);
Helpful Links¶
CREATE FOREIGN TABLE (for GDS Import and Export), DROP FOREIGN TABLE