github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/table/drop_table2.sql (about)

     1  drop table if exists t1;
     2  create table t1(a int);
     3  show tables;
     4  
     5  begin;
     6  show tables;
     7  show columns from t1;
     8  drop table t1;
     9  show tables;
    10  create table t1(a int,b int);
    11  show tables;
    12  show columns from t1;
    13  create table t2(a int);
    14  show tables;
    15  show columns from t2;
    16  rollback;
    17  show tables;
    18  show columns from t1;
    19  
    20  begin;
    21  show tables;
    22  show columns from t1;
    23  drop table t1;
    24  show tables;
    25  create table t1(a int, b int);
    26  show tables;
    27  show columns from t1;
    28  create table t2(a int);
    29  show tables;
    30  commit;
    31  show tables;
    32  
    33  drop table if exists t1;
    34  drop table if exists t2;