The ALTER TABLE command modify an existing table.SQL Syntax:
ALTER TABLE table_name (
ADD
<column_def> [,...n]
| DROP
<column_def> [,...n]
)
Parameters:
table_name |
|
The name of the table.
|
ADD |
|
Add one or more columns to the table.
|
DROP |
|
Currently not implemented. If you need it then contact the support.
|
<column_def> |
|
A column definition like it used in CREATE TABLE. |
see also::
SQL Syntax
|