skip to main content
SQL Statements and Extensions for the Salesforce Driver : Alter Table : Altering a Remote Table
  
Altering a Remote Table
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 Add Clause: 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.
* Add Clause: Columns
* Add Clause: Constraints
* Drop Clause: Columns