GBase8a mpp如何查看表的tableid_方式一

1、通过show full create table 查看，TID即为该表的tableid

gbase> show full create table t1;

+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Table | Create Table                                                                                                                                                                                                                    |

+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| t1    | CREATE TABLE "t1" (

  "a" int(11) DEFAULT NULL,

  "b" varchar(40) DEFAULT NULL,

  "c" date DEFAULT NULL

) ENGINE=EXPRESS DISTRIBUTED BY('a') TID(5) UID(1) DEFAULT CHARSET=utf8 TABLESPACE='sys_tablespace' COLUMN_IDS(0, 1, 2) |

+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (Elapsed: 00:00:00.00)