github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/logictest/testdata/logic_test/show_create (about)

     1  # LogicTest: !3node-tenant
     2  statement ok
     3  CREATE TABLE c (
     4  	a INT NOT NULL,
     5  	b INT NULL,
     6  	INDEX c_a_b_idx (a ASC, b ASC),
     7  	FAMILY fam_0_a_rowid (a, rowid),
     8  	FAMILY fam_1_b (b)
     9  )
    10  
    11  statement ok
    12  COMMENT ON TABLE c IS 'table'
    13  
    14  statement ok
    15  COMMENT ON COLUMN c.a IS 'column'
    16  
    17  statement ok
    18  COMMENT ON INDEX c_a_b_idx IS 'index'
    19  
    20  query TT colnames
    21  SHOW CREATE c
    22  ----
    23  table_name create_statement
    24  c           CREATE TABLE c (
    25              a INT8 NOT NULL,
    26              b INT8 NULL,
    27              INDEX c_a_b_idx (a ASC, b ASC),
    28              FAMILY fam_0_a_rowid (a, rowid),
    29              FAMILY fam_1_b (b)
    30  );
    31  COMMENT ON TABLE c IS 'table';
    32  COMMENT ON COLUMN c.a IS 'column';
    33  COMMENT ON INDEX c_a_b_idx IS 'index'