skip to main content
Supported SQL Statements and Extensions for the Salesforce Driver : Alter Table : Altering a Local Table
  
Altering a Local Table
Purpose
Adds a column, removes a column, or redefines a column in a table. The table being altered can be either a remote or local table. A remote table is a Salesforce object and is exposed in the SFORCE schema. A local table is maintained by the driver and is local to the machine on which the driver is running. A local table is exposed in the PUBLIC schema.
Syntax
ALTER TABLE table_name
[add_clause]
[drop_clause]
[rename_clause]
where:
table_name
specifies an existing local table.
add_clause
specifies a column or constraint to be added to the table. See Add Clause: Columns and Add Clause: Constraintsfor a complete explanation.
drop_clause
specifies a column or constraint to be dropped from the table. See Drop Clause: Columns and Drop Clause: Constraints for a complete explanation.
rename_clause
specifies a new name for the table. See Rename Clause for a complete explanation.
* Add Clause: Columns
* Add Clause: Constraints
* Drop Clause: Columns
* Drop Clause: Constraints
* Rename Clause