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

     1  create table test(a int);
     2  insert into test values(1);
     3  create table new_test like test;
     4  show create table new_test;
     5  drop table test;
     6  drop table new_test;
     7  
     8  create database test1;
     9  use test1;
    10  create table test(a int);
    11  insert into test values(1);
    12  create database test2;
    13  use test2;
    14  create table new_test like test1.test;
    15  show create table new_test;
    16  drop database test1;
    17  drop database test2;
    18  
    19  create database test1;
    20  use test1;
    21  create table test(a int);
    22  insert into test values(1);
    23  create table test like test;
    24  create view view1 as select * from test;
    25  show create view view1;
    26  create table new_test like view1;
    27  drop database test1;