                     ----------  Create or Drop Table  ----------

   "create table" ޥɤϥǡ١˥ơ֥˻Ѥޤ

[ʸ1]

        create [table] TABLE  | (ITEM {, ITEM} [, CONSTRAINT {, CONSTRAINT}])  |
                              | set ITEM {, ITEM} [, CONSTRAINT {, CONSTRAINT}]|

                           [locate [in] LOCATION_NAME];

        ITEM :  ATTR_NAME [DATATYPE [(PARAMETER {, PARAMETER})]
                              [[not] null]
                              [[not] encrypted]
                              [ATTR_CONSTRANT]].

ATTR_CONSTRAINT :

     a) primary key [KEY_NAME] [| btree      |]
                                | timeseries |
     b) foreign key [KEY_NAME] [| btree      |] references TABLE (ATTR_NAME)
                                | timeseries |

CONSTRAINT :

     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})

ǡ׵ᤵ줿°ե᡼ϡޥɼȤ˴ޤޤޤơ
̾ϡTABLE˻ꤵޤ

"Not Null" ϡͤϤƤ뤳Ȥݾڤ˻ꤷޤ

CONSTRAINT ϡPrimary/ForeignKey 뤿ˡȤȤǤޤ

locateץץϡơ֥ξ뤿ˡȤȤǤޤ

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

                help datatypes;

[ʸ2]

        create [table] TABLE [locate [in] LOCATION_NAME] [from FILE] ;


ơ֥̾ TABLE ǡɬפʾե FILE ɤ߹ߤޤ 
ꤹեϡ "display TABLE dump into FILE' ޥɤǺեޥå
ʤƤϤʤޤ

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

                help display;

å⡼ɤˤꡢɬפʾϤ뤳ȤǤޤ

                help ia_create;

[ʸ3]

        create [and insert into] replicate [table] TABLE
            from REPLICATION_MASTER_INFO;

REPLICATION_MASTER_INFO 

     a)  SERVER_NAME:DB_NAME:TABLE_NAME

     b)  SERVER_NAME:DB_NAME..TABLE_NAME

ΥޥɤȤäƥޥơ֥Υץꥱȥơ֥ޤand
insert into ץС줫顢󥯥ʥޤ

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

               help replication;



"drop table" ޥɤϡơ֥ȤڤƤƤǡ١
˻Ѥޤ

[ʸ]

   drop [table] TABLE [with force];

⤷with forceץץ󤬻ꤵСơ֥뤴ȡΥƥĤϡ
бPrimary/Foreign Keyϡץꥱץꥱȥȥȴ
Ϣץꥱޥơ֥åˡǡ١
ޤ

with forceץץϡcascadeddropפȰ㤤ޤߡcascaded
dropפϡEmpressǥݡȤƤޤ

ΥޥɤդƻѤƤ
