|
<< Click to Display Table of Contents >> ALTER TABLE Command |
  
|
|
<< Click to Display Table of Contents >> ALTER TABLE Command |
|
ALTER TABLE allows you to change the structure of an existing table.
ALTER TABLE [ MEMORY ] table_name alter_specification
where alter_specification is:
ADD ( [ [ IF NOT EXISTS ] column_definition ] [, ... ] [ index_definition ] [, ... ] )
| MODIFY ( [ column_definition ] [, ... ] )
| DROP ( [ column_name ] [, ... ] )
| RENAME [ COLUMN ] old_column_name [ TO ] new_column_name
| RENAME [ TABLE ] [ TO ] new_table_name
ALTER TABLE allows you to change the structure of an existing table. For example, you can add or delete columns, create indexes, change the type of existing columns, or rename columns or the table itself.
MEMORY
If MEMORY keyword is specified before the table_name then an in-memory table will be altered, not a disk one.
table_name
The name of the table to be altered.
ADD
Adds the new column(s) and index(es) using the same syntax as CREATE TABLE.
IF NOT EXISTS
If this keyword is specified, the coulmn will be created, only if there is no existing column with the same name. If this keyword is not specified and the column already exists, an exception will be raised.
MODIFY
Changes the column(s) settings such as data type, size, default value, etc..
DROP
Deletes the specified column(s).
RENAME COLUMN
Changes a name of a column to the new_column_name value.
RENAME TABLE
Changes a name of a table to the new_table_name value.
Example:
ALTER TABLE employee ADD (height Float);
__________________________