Mariadb show table status

---

---

MySQL SHOW TABLE STATUS Statement

The CREATE TABLE statement is used to create tables in MYSQL database. Here, you need to specify the name of the table and, definition (name and datatype) of each column.

The SHOW TABLE STATUS Statement of MySQL provides information about the non-TEMPORARY tables in a database.

Syntax

Following is the syntax of the SHOW TABLES Statement −

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

Example

Assume we have created 4 tables in the current database using the CREATE statement as shown below −

CREATE TABLE TestTable1(value VARCHAR(10)); CREATE TABLE TestTable2(value VARCHAR(10)); CREATE TABLE TestTable3(value VARCHAR(10)); CREATE TABLE TestTable4(value VARCHAR(10));

Following statement displays the information about the non-temporary trebles in the current database −

SHOW TABLE STATUS\G;

Output

Once the query is executed, it will produce the following output −

*************** 1.

row *************** Name: testtable1 Engine: InnoDB Version: 10

show table status postgres

show table status postgresql