表组可以在创建表的时候指定，SQL 查询语法格式如下：

    1. CREATE TABLE table_name ( 
    2. column_name data_type [, column_name data_type] 
    3. ) TABLEGROUP tablegroup_name ;

    示例：创建表时指定表组。

    如下创建订单表和订单明细表，业务上这两个表经常要关联查询，所以建议放到同一个表组中。

    1. obclient> create table ordr (
    2.     o_w_id int
    3.     , o_d_id int
    4.     , o_id int
    5.     , o_c_id int
    6.     , o_carrier_id int
    7.     , o_ol_cnt int
    8.     , o_all_local int
    9.     , o_entry_d date
    10.     , index iordr(o_w_id, o_d_id, o_c_id, o_id) local
    11.     , primary key ( o_w_id, o_d_id, o_id )
    12. )tablegroup tpcc_group partition by hash(o_w_id) partitions 6;
    13. Query OK, 0 rows affected (0.13 sec)
    15. obclient> create table ordl (
    16.     ol_w_id int
    17.     , ol_d_id int
    18.     , ol_o_id int
    19.     , ol_number int
    20.     , ol_delivery_d date
    21.     , ol_amount decimal(6, 2)
    22.     , ol_i_id int
    23.     , ol_supply_w_id int
    24.     , ol_quantity int
    25.     , ol_dist_info char(24)
    26.     , primary key (ol_w_id, ol_d_id, ol_o_id, ol_number )
    27. )tablegroup tpcc_group partition by hash(ol_w_id) partitions 6;