Trafodion 查看表的创建时间与修改时间

最新推荐文章于 2022-09-08 11:25:36 发布

原创

最新推荐文章于 2022-09-08 11:25:36 发布 · 500 阅读

收录于

Trafodion中每个对象（如表、索引等）创建后，会在元数据表中增加相应的记录，主要元数据表为"_MD_".objects。
以下是"_MD_".objects的表结构，

SQL>showddl "_MD_".objects;

 
CREATE TABLE TRAFODION."_MD_".OBJECTS
  ( 
    CATALOG_NAME                     VARCHAR(256 BYTES) CHARACTER SET UTF8
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
  , SCHEMA_NAME                      VARCHAR(256 BYTES) CHARACTER SET UTF8
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
  , OBJECT_NAME                      VARCHAR(256 BYTES) CHARACTER SET UTF8
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
  , OBJECT_TYPE                      CHAR(2) CHARACTER SET ISO88591 COLLATE
      DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
  , OBJECT_UID                       LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
      NOT SERIALIZED
  , CREATE_TIME                      LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
      NOT SERIALIZED
  , REDEF_TIME