ALTER TABLE

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

 

 

 


100% pure Java DBMS
Mirror Site