SHOW

Description

SHOW displays values of the current GUC parameters and information about database objects, such as database information, table information, column information, and server status.

Precautions

To display database object information using the SHOW syntax, you must have the corresponding permissions. For details, see Parameters.

Syntax

SHOW 
  { 
    [VARIABLES LIKE] configuration_parameter | 
    TIME ZONE | 
    TRANSACTION ISOLATION LEVEL | 
    SESSION AUTHORIZATION |
    ALL
  };

SHOW {CHARACTER SET | CHARSET} [like_or_where];
SHOW COLLATION [like_or_where];
SHOW [FULL] COLUMNS FROM [tbl_name | db_name.tbl_name] [FROM db_name] [like_or_where];
SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name;
SHOW CREATE TABLE [tbl_name | db_name.tbl_name];
SHOW CREATE VIEW [view_name | db_name.view_name];
SHOW [DATABASES | SCHEMAS] [like_or_where];
SHOW [STORAGE] ENGINES;
SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr];
SHOW [FULL] PROCESSLIST;
SHOW [GLOBAL | SESSION ] STATUS [like_or_where];
SHOW [GLOBAL | SESSION] VARIABLES [like_or_where];
SHOW [FULL] TABLES [{FROM | IN} db_name][LIKE 'pattern' | WHERE expr];
SHOW TABLE STATUS [{FROM | IN}db_name][LIKE 'pattern' | WHERE expr];

like_or_where: 
  {
    LIKE 'pattern' |
    WHERE expr
  };

Parameters

configuration_parameter
Specifies the name of the GUC parameter.

Value range: GUC parameters. You can view the GUC parameters by using the SHOW ALL statement.
TIME ZONE
Specifies the time zone.
TRANSACTION ISOLATION LEVEL
Specifies the transaction isolation level.
SESSION AUTHORIZATION
Specifies the user identifier of the current session.
{CHARACTER SET | CHARSET}
Displays all available character sets. You can use the LIKE clause to perform fuzzy match on column names or use the WHERE clause to specify more general selection conditions.

SHOW CHARACTER SET displays the following column information:
- Charset: character set name.
- Description: character set description.
- Default collation: default collation of the character set.
- Maxlen: maximum number of bytes required to store a character.
COLLATION
Displays the collation supported by a server. You can use the LIKE clause to perform fuzzy match on column names or use the WHERE clause to specify more general selection conditions.

SHOW COLLATION displays the following column information:
- Collation: collation name.
- Charset: name of a character set with which a collation is joined.
- Id: collation ID.
- Default: specifies whether a collation is the default for its character set.
- Compiled: compatible column. The default value is Yes.
- Sortlen: related to the amount of memory required to sort strings represented by character sets.
[FULL] COLUMNS FROM [tbl_name | db_name.tbl_name] [FROM db_name] [like_or_where]
Displays information about columns in a specified table. It is also applicable to views. You must have the USAGE permission on the schema to which the specified table belongs and any table-level or column-level permissions on the specified table. Only columns with the SELECT, INSERT, UPDATE, REFERENCES, and COMMENT permissions are displayed. You can use the LIKE clause to perform fuzzy match on column names or use the WHERE clause to specify more general selection conditions.

FULL: (Optional) The output additionally contains column collation, comments, and permission information. You can use the db_name.tbl_name or FROM db_name statement to specify a schema where a table is located. When both statements are used, the FROM db_name statement takes precedence over the db_name.tbl_name statement.
SHOW COLUMNS displays the following column information:
- Field: column name.
- Type: column data type.
- Collation: collation of the character type, which is displayed only when the keyword FULL is declared.
- Null: specifies whether a column value can be NULL. YES indicates that the value can be NULL. NO indicates that the value cannot be NULL.
- Key: specifies whether a column is indexed. The options are as follows:
  - PRI: specifies that the column is indexed by a primary key.
  - UNI: specifies that the column is the first column in a unique index.
  - MUL: specifies that the column is the first column in a non-unique index.
  - NULL: specifies that the column is not indexed or is not the first column of a unique or non-unique index.
- Default: default value of a column.
- Extra: additional information about a column. The options are as follows:
  - auto_increment: specifies that the column is an auto-increment column.
  - on update CURRENT_TIMESTAMP: specifies that the column has the ON UPDATE constraint.
  - VIRTUAL GENERATED: indicates a virtual generated column.
  - STORED GENERATED: indicates a stored generated column.
- Privilege: permission of a user on a column, which is displayed only when the keyword FULL is used.
- Comment: column comment, which is displayed only when the keyword FULL is used.
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
Displays the CREATE DATABASE statement used to create a specified database. You must have the USAGE permission on a specified schema.

DATABASE and SCHEMA are synonyms. If the SHOW statement contains the IF NOT EXISTS statement, the output CREATE DATABASE statement also contains IF NOT EXISTS.
CREATE TABLE [tbl_name | db_name.tbl_name]
Displays the CREATE TABLE statement for creating a specified table. When it applies to views, it has the same function as SHOW CREATE VIEW. You must have the USAGE permission on the schema to which the specified table belongs and any table-level permissions on the specified table.

You can use the db_name.tbl_name statement to specify the schema to which the specified table belongs. After the GUC compatibility parameter m_format_dev_version is set to 's2', the returned result set may change. For details, see the SHOW CREATE TABLE syntax in "MySQL Compatibility Description > M-compatible Mode > SQL > DML" in Compatibility Description.
CREATE VIEW [view_name | db_name.view_name]
Displays the CREATE VIEW statement for creating a specified view. You must have the USAGE permission on the schema to which the specified view belongs and any table-level permissions on the specified view. You can use the db_name.view_name statement to specify the schema to which the specified view belongs. When m_format_behavior_compat_options is set to enable_precision_decimal, implicit type conversion information is not displayed.
[STORAGE] ENGINES
Specifies storage engines supported by a database server.
[GLOBAL | SESSION ] STATUS
Displays the number of database connections and running time. If GLOBAL or SESSION is not explicitly specified, the current session is used by default.
- GLOBAL: displays the number of global database connections and running time.
- SESSION: displays the number of database connections and running time of the current session.
DATABASES | SCHEMAS
Specifies all schemas in the current database. The query result uses the character set utf8mb4 and collation utf8mb4_bin.
INDEX | INDEXES | KEYS
Displays index information. Temporary tables in GaussDB are stored in independent temporary schemas. When using the FROM or IN db_name condition to display the index information of a specified temporary table, you must specify db_name as the schema where the temporary table is located. Otherwise, the system displays a message indicating that the temporary table does not exist. In the query result, the Table, Index_type, and Index_comment columns use the character set utf8mb4 and collation utf8mb4_bin. The Key_name, Column_name, Collation, Null, and Comment columns use the character set utf8mb4 and collation utf8mb4_general_ci.
[FULL] PROCESSLIST
Displays thread information on the current server. If a user does not have the SYSADMIN permission, the user can only view information about its own threads. The displayed content is the same as that in the information_schema.processlist view. For details about the returned result, see processlist. If FULL is not specified, only the first 100 characters are displayed in the Info column in the returned result.
ALL
Specifies all GUC parameters.
[GLOBAL | SESSION] VARIABLES
Displays the values of database system variables. If GLOBAL or SESSION is not explicitly specified, the current session is used by default. You can use the LIKE clause to perform fuzzy match on column names or use the WHERE clause to specify more general selection conditions.
- GLOBAL: displays values of global system variables. These values are used to initialize the corresponding session variables for a new connection to a database. If a variable does not have a global value, no value is displayed.
- SESSION: displays values of system variables of the current session. If a variable has no session value, the global value is displayed.
[FULL] TABLES [{FROM | IN} db_name][LIKE 'pattern' | WHERE expr]
Queries tables or views in a specified database. By default, the database used for query is used. Temporary tables are not included. To specify a database, a user must have the database permissions. The query results are sorted in ascending order. The query result uses the character set utf8mb4 and collation utf8mb4_bin.
- FULL (optional): specifies that the displayed information contains the Table_type column.
- {FROM | IN} db_name: queries tables in the database specified by db_name.
- LIKE 'pattern': filters tables that meet the pattern condition. If the target database is information_schema, the pattern is converted to lowercase letters before matching.
- WHERE expr: filters tables that meet the expr condition.

TABLE STATUS [{FROM | IN}db_name][LIKE 'pattern' | WHERE expr]

In M-compatible databases, the SHOW TABLE STATUS syntax is used to display information about tables and views. If no schema is specified, the current schema is specified by default, excluding temporary tables. The character set and collation used in the query result are displayed in the corresponding columns in information_schema.tables.

{FROM | IN} db_name: queries tables in the database specified by db_name.
LIKE 'pattern': filters tables that meet the pattern condition. If the target database is information_schema, the pattern is converted to lowercase letters before matching.
WHERE expr: filters tables that meet the expr condition.

**Table 1** SHOW TABLE STATUS query result
Display Column	Description	Mapping Column
Name	Table name.	information_schema.tables.TABLE_NAME
Engine	Engine used by a table.	information_schema.tables.ENGINE
Version	Version.	information_schema.tables.VERSION
Row_format	Row format.	information_schema.tables.ROW_FORMAT
Rows	Number of rows in a table.	information_schema.tables.TABLE_ROWS
Avg_row_length	Average length.	information_schema.tables.AVG_ROW_LENGTH
Data_length	Data file length.	information_schema.tables.DATA_LENGTH
Max_data_length	Maximum length of a data file.	information_schema.tables.MAX_DATA_LENGTH
Index_length	Index length.	information_schema.tables.INDEX_LENGTH
Data_free	Number of bytes that have been allocated but not used.	information_schema.tables.DATA_FREE
Auto_increment	Next automatic increment.	information_schema.tables.AUTO_INCREMENT
Create_time	Time when a table is created.	information_schema.tables.CREATE_TIME
Update_time	Time when the data was updated last time.	information_schema.tables.UPDATE_TIME
Check_time	Last check time of a table.	information_schema.tables.CHECK_TIME
Collation	Collation of a table.	information_schema.tables.TABLE_COLLATION
Checksum	Checksum.	information_schema.tables.CHECKSUM
Create_options	Options for creating a table.	information_schema.tables.CREATE_OPTIONS
Comment	Table comments.	information_schema.tables.TABLE_COMMENT

Example

SHOW syntax

-- Show the value of timezone.
m_db=# SHOW timezone;

-- Show all parameters.
m_db=# SHOW ALL;

-- Show all parameters whose names contain var.
m_db=# SHOW VARIABLES LIKE var;

SHOW CHARACTER SET syntax

-- Show all available character sets.
m_db=# SHOW CHARACTER SET;
 charset | description | default collation  | maxlen 
---------+-------------+--------------------+--------
 UTF8    |             | utf8mb4_general_ci |       
(1 row)

SHOW COLLATION syntax

-- Display the collation supported by a server.
m_db=# SHOW COLLATION;
     collation      | charset | id | default | compiled | sortlen 
--------------------+---------+----+---------+----------+---------
 C                  | UTF8    |    |         | Yes      |        
 default            | UTF8    |    |         | Yes      |        
 POSIX              | UTF8    |    |         | Yes      |        
 utf8_bin           | UTF8    |    |         | Yes      |        
 utf8_general_ci    | UTF8    |    |         | Yes      |        
 utf8mb4_0900_ai_ci | UTF8    |    |         | Yes      |        
 utf8mb4_bin        | UTF8    |    |         | Yes      |        
 utf8mb4_general_ci | UTF8    |    | Yes     | Yes      |        
 utf8mb4_unicode_ci | UTF8    |    |         | Yes      |        
 utf8_unicode_ci    | UTF8    |    |         | Yes      |        
(10 rows)

SHOW COLUMNS syntax

-- Create the t01 table.
m_db=# CREATE TABLE t01 (
	c1 int AUTO_INCREMENT COMMENT 'this is c1',
	c2 int NOT NULL CHECK (c2 > 0),
	c3 text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT 'this is c3',
	c4 int DEFAULT 5 COMMENT 'this is c4',
	c5 datetime ON UPDATE current_timestamp COMMENT 'this is c5',
	c6 int GENERATED ALWAYS AS (c2 + c4) STORED COMMENT 'this is c6',
	c7 int UNIQUE COMMENT 'this is c7',
	c8 int,
	c9 text CHARSET utf8mb4 COLLATE utf8mb4_bin COMMENT 'this is c9',
	c10 int COMMENT 'this is c10',
	c11 int COMMENT 'this is c11',
	c12 int COMMENT 'this is c12',
	CONSTRAINT PRIMARY KEY (c1) USING btree COMMENT 'this is primary key',
	CONSTRAINT FOREIGN KEY (c8) REFERENCES t01(c1),
	CONSTRAINT CHECK (c10 > 0),
	CONSTRAINT UNIQUE (c11) COMMENT 'this is unique constraint',
	c13 text COMMENT 'this is c13',
	c14 int COMMENT 'this is c14',
	INDEX USING btree (c13(10)) COMMENT 'this is index',
	INDEX (c13(10),c14) USING btree COMMENT 'this is index too'
);

-- Display column information.
m_db=# SHOW FULL COLUMNS FROM t01;
 Field |   Type   |     Collation      | Null | Key | Default |            Extra            |           Privileges            |   Comment   
-------+----------+--------------------+------+-----+---------+-----------------------------+---------------------------------+-------------
 c1    | integer  |                    | NO   | PRI |         | auto_increment              | select,insert,update,references | this is c1
 c2    | integer  |                    | NO   |     |         |                             | select,insert,update,references | 
 c3    | text     | utf8mb4_bin        | YES  |     |         |                             | select,insert,update,references | this is c3
 c4    | integer  |                    | YES  |     | 5       |                             | select,insert,update,references | this is c4
 c5    | datetime |                    | YES  |     |         | on update CURRENT_TIMESTAMP | select,insert,update,references | this is c5
 c6    | integer  |                    | YES  |     |         | STORED GENERATED            | select,insert,update,references | this is c6
 c7    | integer  |                    | YES  | UNI |         |                             | select,insert,update,references | this is c7
 c8    | integer  |                    | YES  |     |         |                             | select,insert,update,references | 
 c9    | text     | utf8mb4_bin        | YES  |     |         |                             | select,insert,update,references | this is c9
 c10   | integer  |                    | YES  |     |         |                             | select,insert,update,references | this is c10
 c11   | integer  |                    | YES  | UNI |         |                             | select,insert,update,references | this is c11
 c12   | integer  |                    | YES  |     |         |                             | select,insert,update,references | this is c12
 c13   | text     | utf8mb4_general_ci | YES  | MUL |         |                             | select,insert,update,references | this is c13
 c14   | integer  |                    | YES  |     |         |                             | select,insert,update,references | this is c14
(14 rows)

m_db=# DROP TABLE t01;

SHOW CREATE DATABASE syntax

-- Create db1.
m_db=# CREATE DATABASE IF NOT EXISTS db1 DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_bin;

-- Show the statement for creating db1.
m_db=# SHOW CREATE DATABASE db1;
 Database |                          Create Database                           
----------+--------------------------------------------------------------------
 db1      | CREATE DATABASE db1 DEFAULT CHARACTER SET UTF8 COLLATE utf8mb4_bin
(1 row)

-- IF NOT EXISTS is contained.
m_db=# SHOW CREATE DATABASE IF NOT EXISTS db1;
 Database |                                 Create Database                                  
----------+----------------------------------------------------------------------------------
 db1      | CREATE DATABASE IF NOT EXISTS db1 DEFAULT CHARACTER SET UTF8 COLLATE utf8mb4_bin
(1 row)

m_db=# DROP DATABASE db1;

SHOW CREATE TABLE syntax

-- Create the t01 table.
m_db=# CREATE GLOBAL TEMPORARY TABLE t01(
	c1 int COMMENT 'this is c1',
	c2 int PRIMARY KEY USING INDEX TABLESPACE pg_default,
	c3 int,
	c4 int,
	CONSTRAINT UNIQUE (c3) COMMENT 'this is unique',
	INDEX idx (c3) COMMENT 'this is index'
) COMMENT 'this is table'
ON COMMIT PRESERVE ROWS;

-- Set the compatibility parameter m_format_dev_version to s2.
m_db=# SET m_format_dev_version='s2';
-- Show the statement for creating the t01 table.
m_db=# SHOW CREATE TABLE t01;
 Table |                                                    Create Table                                                     
-------+---------------------------------------------------------------------------------------------------------------------
 t01   | SET search_path = public;                                                                                          +
       | CREATE GLOBAL TEMPORARY TABLE t01 (                                                                                +
       |     c1 integer COMMENT 'this is c1',                                                                               +
       |     c2 integer NOT NULL,                                                                                           +
       |     c3 integer,                                                                                                    +
       |     c4 integer,                                                                                                    +
       |     CONSTRAINT t01_pkey PRIMARY KEY (c2) WITH (storage_type=USTORE) USING ubtree,                                  +
       |     CONSTRAINT t01_c3_key UNIQUE (c3) WITH (storage_type=USTORE) USING ubtree COMMENT 'this is unique'             +
       | )                                                                                                                  +
       | CHARACTER SET = "UTF8" COLLATE = "utf8mb4_general_ci" COMMENT 'this is table'                                      +
       | WITH (orientation=row, compression=no, storage_type=USTORE, segment=off)                                           +
       | ON COMMIT PRESERVE ROWS;                                                                                           +
       | CREATE INDEX idx USING ubtree ON t01 (c3) WITH (storage_type=USTORE) TABLESPACE pg_default COMMENT 'this is index';
(1 row)

-- Set the compatibility parameter m_format_dev_version to an empty value.
m_db=# SET m_format_dev_version='';
-- Show the statement for creating the t01 table.
m_db=# SHOW CREATE TABLE t01;
 Table |                                                    Create Table                                                     
-------+---------------------------------------------------------------------------------------------------------------------
 t01   | SET search_path = public;                                                                                          +
       | CREATE GLOBAL TEMPORARY TABLE t01 (                                                                                +
       |     c1 integer,                                                                                                    +
       |     c2 integer NOT NULL,                                                                                           +
       |     c3 integer,                                                                                                    +
       |     c4 integer                                                                                                     +
       | )                                                                                                                  +
       | CHARACTER SET = "UTF8" COLLATE = "utf8mb4_general_ci"                                                              +
       | WITH (orientation=row, compression=no, storage_type=USTORE, on_commit_delete_rows=false, segment=off);             +
       | COMMENT ON TABLE t01 IS 'this is table';                                                                           +
       | COMMENT ON COLUMN t01.c1 IS 'this is c1';                                                                          +
       | CREATE INDEX idx USING ubtree ON t01 (c3) WITH (storage_type=USTORE) TABLESPACE pg_default COMMENT 'this is index';+
       | COMMENT ON INDEX idx IS 'this is index';                                                                           +
       | ALTER TABLE t01 ADD CONSTRAINT t01_c3_key UNIQUE USING ubtree (c3) WITH (storage_type=USTORE);                     +
       | COMMENT ON INDEX t01_c3_key IS 'this is unique';                                                                   +
       | ALTER TABLE t01 ADD CONSTRAINT t01_pkey PRIMARY KEY USING ubtree  (c2) WITH (storage_type=USTORE);
(1 row)

m_db=# DROP TABLE t01;

SHOW CREATE VIEW syntax

-- Create a view.
m_db=# CREATE TABLE t01 (c1 int, c2 int, c3 int);
m_db=# CREATE VIEW v01 AS SELECT c1 AS col1, c3 AS col2 FROM t01;

-- Show the statement for creating the v01 view.
m_db=# SHOW CREATE VIEW v01;
 View |                   Create View                   | character_set_client | collation_connection 
------+-------------------------------------------------+----------------------+----------------------
 v01  | CREATE VIEW v01 AS                             +|                      | 
      | SELECT t01.c1 AS col1, t01.c3 AS col2 FROM t01; |                      | 
(1 row)

m_db=# DROP VIEW v01;
m_db=# DROP TABLE t01;

SHOW PROCESSLIST syntax

-- Connect to the M-compatible database db_m as the test user and display the thread information.
m_db=# SHOW FULL PROCESSLIST;
       Id        | User | Host |  db  | Command | Time | State |          Info          
-----------------+------+------+------+---------+------+-------+------------------------
 139880022669056 | test |      | m_db |         |    0 |       | SHOW FULL PROCESSLIST;
(1 row)

SHOW INDEX syntax

-- Create an index and a table.
m_db=# CREATE TABLE t01 (c1 int PRIMARY KEY);

-- Show index information.
m_db=# SHOW INDEX from t01;
 Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment 
-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------
 t01   |          0 | PRIMARY  |            1 | c1          | A         |           0 |          |        |      | UBTREE     |         | 
(1 row)

SHOW VARIABLES syntax

-- Show values of global system variables.
m_db=# SHOW GLOBAL VARIABLES LIKE 'a_format%';
              Variable_name               | Value 
------------------------------------------+-------
 a_format_copy_version                    | 
 a_format_date_timestamp                  | off
 a_format_dev_version                     | 
 a_format_disable_func                    | 
 a_format_load_with_constraints_violation | 
 a_format_version                         | 
(6 rows)

-- Show values of system variables of the current session.
m_db=# SHOW SESSION VARIABLES LIKE 'query_%';
  Variable_name   |  Value  
------------------+---------
 query_max_mem    | 0
 query_dop        | 1
 query_mem        | 0
 query_cache_type | 0
 query_band       | 
 query_cache_size | 1048576
(6 rows)

SHOW TABLES syntax

m_db=# CREATE SCHEMA sc_test;
CREATE SCHEMA
m_db=# USE sc_test;
SET
m_db=# CREATE TABLE t1(a int, b int);
CREATE TABLE
m_db=# CREATE TABLE t2(a int, b int);
CREATE TABLE
m_db=# SHOW TABLES;
 Tables_in_sc_test
-------------------
 t1
 t2
(2 rows)
m_db=# SHOW FULL TABLES;
 Tables_in_sc_test | Table_type
-------------------+------------
 t1                | BASE TABLE
 t2                | BASE TABLE
(2 rows)

m_db=# SHOW TABLES FROM sc_test;
 Tables_in_sc_test
-------------------
 t1
 t2
(2 rows)
m_db=# SHOW TABLES LIKE "%1";
 Tables_in_sc_test (%1)
------------------------
 t1
(1 row)

m_db=# SHOW TABLES LIKE "t%";
 Tables_in_sc_test (t%)
------------------------
 t1
 t2
(2 rows)

m_db=# SHOW TABLES WHERE Tables_in_sc_test='t1';
 Tables_in_sc_test
-------------------
 t1
(1 row)
m_db=# DROP SCHEMA sc_test;
NOTICE:  drop cascades to 2 other objects
DETAIL:  drop cascades to table sc_test.t1
drop cascades to table sc_test.t2
DROP SCHEMA

SHOW TABLE STATUS syntax

m_db=# CREATE SCHEMA sc_test;
CREATE SCHEMA
m_db=# USE sc_test;
SET
m_db=# CREATE TABLE t1(a int, b int);
CREATE TABLE
m_db=# CREATE TABLE t2(a int, b int);
CREATE TABLE
m_db=# SHOW TABLE STATUS;
 Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment |     Create_time     | Update_time | Check_time |     Collation      | Checksum |                               Create_options                                | Comment
------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+-----------------------------------------------------------------------------+---------
 t1   | Ustore |         |            | 0    |                | 0           |                 | 0            |           |                | 2024-04-21 15:56:25 |             |            | utf8mb4_general_ci |          | orientation=row compression=no storage_type=USTORE collate=1537 segment=off |
 t2   | Ustore |         |            |                | 0           |                 | 0            |           |                | 2024-04-21 15:56:32 |             |            | utf8mb4_general_ci |          | orientation=row compression=no storage_type=USTORE collate=1537 segment=off |
(2 rows)

m_db=# SHOW TABLE STATUS FROM sc_test;
 Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment |     Create_time     | Update_time | Check_time |     Collation      | Checksum |                               Create_options                                | Comment
------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+-----------------------------------------------------------------------------+---------
 t1   | Ustore |         |            | 0    |                | 0           |                 | 0            |           |                | 2024-04-21 15:56:25 |             |            | utf8mb4_general_ci |          | orientation=row compression=no storage_type=USTORE collate=1537 segment=off |
 t2   | Ustore |         |            | 0    |                | 0           |                 | 0            |           |                | 2024-04-21 15:56:32 |             |            | utf8mb4_general_ci |          | orientation=row compression=no storage_type=USTORE collate=1537 segment=off |
(2 rows)

m_db=# SHOW TABLE STATUS FROM sc_test LIKE 't%';
 Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment |     Create_time     | Update_time | Check_time |     Collation      | Checksum |                               Create_options                                | Comment
------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+-----------------------------------------------------------------------------+---------
 t1   | Ustore |         |            | 0    |                | 0           |                 | 0            |           |                | 2024-04-21 15:56:25 |             |            | utf8mb4_general_ci |          | orientation=row compression=no storage_type=USTORE collate=1537 segment=off |
 t2   | Ustore |         |            | 0    |                | 0           |                 | 0            |           |                | 2024-04-21 15:56:32 |             |            | utf8mb4_general_ci |          | orientation=row compression=no storage_type=USTORE collate=1537 segment=off |
(2 rows)

m_db=# SHOW TABLE STATUS FROM sc_test LIKE '%1';
 Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment |     Create_time     | Update_time | Check_time |     Collation      | Checksum |                               Create_options                                | Comment
------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+-----------------------------------------------------------------------------+---------
 t1   | Ustore |         |            | 0    |                | 0           |                 | 0            |           |                | 2024-04-21 15:56:25 |             |            | utf8mb4_general_ci |          | orientation=row compression=no storage_type=USTORE collate=1537 segment=off |
(1 row)
                                                  ^
m_db=# SHOW TABLE STATUS FROM sc_test WHERE Name='t1';
 Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment |     Create_time     | Update_time | Check_time |     Collation      | Checksum |                               Create_options                                | Comment
------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+-----------------------------------------------------------------------------+---------
 t1   | Ustore |         |            | 0    |                | 0           |                 | 0            |           |                | 2024-04-21 15:56:25 |             |            | utf8mb4_general_ci |          | orientation=row compression=no storage_type=USTORE collate=1537 segment=off |
(1 row)

m_db=# SHOW TABLE STATUS FROM sc_test WHERE Name LIKE 't%';
 Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment |     Create_time     | Update_time | Check_time |     Collation      | Checksum |                               Create_options                                | Comment
------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+-----------------------------------------------------------------------------+---------
 t1   | Ustore |         |            | 0    |                | 0           |                 | 0            |           |                | 2024-04-21 15:56:25 |             |            | utf8mb4_general_ci |          | orientation=row compression=no storage_type=USTORE collate=1537 segment=off |
 t2   | Ustore |         |            | 0    |                | 0           |                 | 0            |           |                | 2024-04-21 15:56:32 |             |            | utf8mb4_general_ci |          | orientation=row compression=no storage_type=USTORE collate=1537 segment=off |
(2 rows)
m_db=# DROP SCHEMA sc_test;
NOTICE:  drop cascades to 2 other objects
DETAIL:  drop cascades to table sc_test.t1
drop cascades to table sc_test.t2
DROP SCHEMA