ALTER FOREIGN TABLE [ IF EXISTS ] { ONLY $name$ | $name$ [ * ] } $action$ [ , ... ] ALTER FOREIGN TABLE [ IF EXISTS ] { ONLY $name$ | $name$ [ * ] } RENAME [ COLUMN ] $column_name$ TO $new_column_name$ ALTER FOREIGN TABLE [ IF EXISTS ] $name$ RENAME TO $new_name$ ALTER FOREIGN TABLE [ IF EXISTS ] $name$ SET SCHEMA $new_schema$ where $action$ is: ADD [ COLUMN ] $column_name$ $data_type$ [ COLLATE $collation$ ] [ $column_constraint$ [ ... ] ] | DROP [ COLUMN ] [ IF EXISTS ] $column_name$ [ RESTRICT | CASCADE ] | ALTER [ COLUMN ] $column_name$ [ SET DATA ] TYPE $data_type$ [ COLLATE $collation$ ] | ALTER [ COLUMN ] $column_name$ SET DEFAULT $expression$ | ALTER [ COLUMN ] $column_name$ DROP DEFAULT | ALTER [ COLUMN ] $column_name$ { SET | DROP } NOT NULL | ALTER [ COLUMN ] $column_name$ SET STATISTICS $integer$ | ALTER [ COLUMN ] $column_name$ SET ( $attribute_option$ = $value$ [ , ... ] ) | ALTER [ COLUMN ] $column_name$ RESET ( $attribute_option$ [ , ... ] ) | ALTER [ COLUMN ] $column_name$ SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN } | ALTER [ COLUMN ] $column_name$ OPTIONS ( [ ADD | SET | DROP ] $option$ ['$value$'] [ , ... ]) | ADD $table_constraint$ [ NOT VALID ] | VALIDATE CONSTRAINT $constraint_name$ | DROP CONSTRAINT [ IF EXISTS ] $constraint_name$ [ RESTRICT | CASCADE ] | DISABLE TRIGGER [ $trigger_name$ | ALL | USER ] | ENABLE TRIGGER [ $trigger_name$ | ALL | USER ] | ENABLE REPLICA TRIGGER $trigger_name$ | ENABLE ALWAYS TRIGGER $trigger_name$ | SET WITHOUT OIDS | INHERIT $parent_table$ | NO INHERIT $parent_table$ | OWNER TO { $new_owner$ | CURRENT_ROLE | CURRENT_USER | SESSION_USER } | OPTIONS ( [ ADD | SET | DROP ] $option$ ['$value$'] [ , ... ]) where $column_constraint$ is: [ CONSTRAINT $constraint_name$ ] { NOT NULL | NULL | CHECK ( $expression$ ) [ NO INHERIT ] | DEFAULT $default_expr$ | GENERATED ALWAYS AS ( $generation_expr$ ) STORED | GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( $sequence_options$ ) ] | UNIQUE [ NULLS [ NOT ] DISTINCT ] $index_parameters$ | PRIMARY KEY $index_parameters$ | REFERENCES $reftable$ [ ( $refcolumn$ ) ] [ MATCH FULL | MATCH SIMPLE ] [ ON DELETE $referential_action$ ] [ ON UPDATE $referential_action$ ] } [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] where $referential_action$ is: { NO ACTION | RESTRICT | CASCADE | SET NULL [ ( $column_name$ [ , ... ] ) ] | SET DEFAULT [ ( $column_name$ [ , ... ] ) ] }