Syntax

ALTER TABLE table_name
[add_clause]
[drop_clause]

where:

table_name
specifies an existing remote table.
add_clause
specifies a column or a foreign key constraint to be added to the table. See "Add Clause: Columns" and "AddClause: Constraints" for a complete explanation.
drop_clause
specifies a column to be dropped from the table. See "Drop Clause: Columns" for a complete explanation.

Notes

  • You cannot drop a constraint from a remote table.