skip to main content
Reference : Supported SQL Statements and Extensions : Alter Table
  

Try DataDirect Drivers Now

Alter Table

Purpose

The Alter Table statement adds a column, removes a column, or redefines a column in a local table. 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: Constraints" for 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.

Notes

*Alter Table for remote tables is not supported.
In this section: 
* Add Clause: Columns
* Add Clause: Constraints
* Drop Clause: Columns
* Drop Clause: Constraints
* Rename Clause