                     ----------  Alter Table  ----------

 "alter table" ޥɤϡơ֥Фƿ°äꡢ¸ߤ
 °ΥǡѤꡢפ°ꡢåɲä
 ꡢơ֥򿷤ǥ쥯ȥ˰ư뤳ȤǤޤޥɤˤ
 å⡼ɤȥޥɥ⡼ɤΣĤμबޤ

 ⤷ơ֥˥ȥꥬСΥޥɤȥꥬǽˤ ̵ˤ
 ϡͥ٤Ѥ뤳ȤǤޤ
 
 ⤷ơ֥˥ץꥱޥȥ꡼СΥޥɤץ
 ޥȥ꡼ͭ/̵ˤơޤϡץꥱ󥨥ȥ꡼
 ѹ뤳ȤǤޤ

 ̤Υơ֥ȥޥơ֥δ֤˥ơ֥뷿Ѥ뤿ˡΥޥɤ
 ȤǤޤ

[ʸ1
 
          alter [table] TABLE ACTION { [:] ACTION };
        
ACTION ϡ

          | add ITEM {,ITEM} [before ATTR_NAME] |
          | change ITEM {, ITEM}                |
          | delete ITEM {, ITEM}                |
          | add    [|   record   |] checksum    |
          |         |   longvar  |              |
          | delete [|   record   |] checksum    |
          |         |   longvar  |              |
          | add    CONSTRAINT1                  |
          | delete CONSTRAINT2                  |
 
ITEM : ATTR_NAME DATATYPE [(PARAMETER {, PARAMETER})]
                 [[not] null] [[not] encrypted]

ITEM2: ATTR_NAME [DATATYPE [(PARAMETER {, PARAMETER})]]
                 [[not] null] [[not] encrypted]

CONSTRAINT1:

     a) primary key [KEY_NAME] [on] (ATTR_NAME {, ATTR_NAME}) [| btree      |]
                                                               | timeseries |

     b) foreign key [KEY_NAME] [on] (ATTR_NAME {, ATTR_NAME}) [| btree      |]
                                                               | timeseries |
                references TABLE (ATTR_NAME {, ATTR_NAME})

CONSTRAINT2:

     a) primary key [KEY_NAME]

     b) foreign key [KEY_NAME] [on] (ATTR_NAME {, ATTR_NAME})
 
[ʸ2] 
        alter TABLE [locate [in] LOCATION_NAME]
 
LOCATION_NAME : ưǥ쥯ȥ̾
 
alter TABLE" ꤹȡå⡼ɤѹ뤳ȤǤޤ
 
˾ɬפʾϡʲ˼ޥɤϤƤ
 
                help rename;
                help ia_alter;
                help datatypes;

[ʸ3]
        alter [table] TABLE | enable  | | all triggers                 |;
                            | disable | | trigger TRIGGER {, TRIGGER } |

Υޥɤϡȥꥬ enable ޤ disable ꤹ˻Ѥޤ

ܺ٤ʾ򻲾ȤˤϡʲΥޥɤѤƲ

                help trigger;

[ʸ4]
        alter [table] TABLE change tigger TRIGGER {, TRIGGER}

              priority FLOAT;

Υޥɤϡȥꥬ̤ͥѹ˻Ѥ롣̤ͥ FLOAT 
ͤˤɽ졢礭̤ͥ⤤ȥꥬȤʤޤ

ܺ٤ʾ򻲾ȤˤϡʲΥޥɤѤƲ

                help trigger;

[ʸ5]
        alter [table] REPLICATION_TABLE | enable  |
                                     | disable |

           | all replication | masters |                            |;
                             | master  |
           | replication master REP_MASTER_INFO {, REP_MASTER_INFO} |

REP_MASTER_INFO :

        a)  SERVER_NAME:DB_NAME:TABLE_NAME

        b)  SERVER_NAME:DB_NAME..TABLE_NAME

REPLICATION_TABLE ϥޥ뤤ϥץꥱȤΥơ֥Ǥ

Υޥɤϡץꥱȥơ֥Υץꥱޥ
꡼ enable/disable Τ˻Ȥޤ

ܺ٤ʾ򻲾ȤˤϡʲΥޥɤѤƲ

                help replication;

[ʸ6]

        alter [table] REPLICATION_TABLE change replication master order
           REP_MASTER_INFO FLOAT {, REP_MASTER_INFO FLOAT};

ΥޥɤȤäƥץꥱޥȥ꡼Ѥ뤳
ǤޤϡFLOAT ˤäƼޤ

ܺ٤ʾ򻲾ȤˤϡʲΥޥɤѤƲ

                help replication;

[ʸ7]
         alter [table] TABLE change table type to
           | master    [table] [for subset on (ATTR_NAME {, ATTR_NAME} )] |;
           | replicate [table]                                            |
           | normal    [table] [with force]                               |

ΥޥɤȤäƥޥץꥱȤȥΡޥΥơ֥δ֤ѹ
뤳ȤǤޤΡޥơ֥뤫ץꥱȤؤľܤΥС
ϤǤޤ

for subset onץץϡΡޥơ֥ޥơ֥ž뤿
ˡñŬѤޤ⤷Ρޥơ֥Υץ饤ޥꥭʤ
СžϤǤޤ

with forceץץϡޥ/ץꥱȥơ֥̤Υơ֥ž
뤿ˡñŬѤ뤳ȤǤޤ⤷ꤵСбץꥱ
ץꥱȤȤץꥱޥϡåޤ 

ܺ٤ʾ򻲾ȤˤϡʲΥޥɤѤƲ

                help replication;
