# SHOW TABLE STATUS

Show tables status information in a SingleStore database.

## Syntax

```

SHOW TABLE STATUS [{FROM | IN} db_name]

```

## Remarks

* `db_name` is the name of a SingleStore database.
* Shows how much memory this table is using for row data.
* Memory for off-row data (such as `VARCHAR`s) is not reported.
* This command can be run on any SingleStore node (see [Node Requirements for SingleStore Commands](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md)).

**Output**

| Column                     | Description                                                                                                         |
| -------------------------- | ------------------------------------------------------------------------------------------------------------------- |
| `Check_time`               | Default is null, used as a placeholder for MySQL compatibility                                                      |
| `Engine`                   | SingleStoreengine image name                                                                                        |
| `Version`                  | Engine version                                                                                                      |
| `Row_format`               | Shows whether the table is a sparse compressed rowstore table                                                       |
| `Rows`                     | Number of rows in the table                                                                                         |
| `Avg_row_length`           | Average memory used per row in the table and is calculated as Data\_length / Rows                                   |
| `Data_length`              | Total memory used for a table                                                                                       |
| `Max_data_length`          | Maximum data length. Default is null, used as a placeholder for MySQL compatibility.                                |
| `Index_length`             | Index length. Default is null, used as a placeholder for MySQL compatibility.                                       |
| `Data_free`                | Data free. Default is null, used as a placeholder for MySQL compatibility.                                          |
| `Auto_increment`           | Default is null, used as a placeholder for MySQL compatibility.                                                     |
| `Create_time`              | Table creation date and time                                                                                        |
| `Update_time`              | Update time                                                                                                         |
| `Check_time`               | Default is null, used as a placeholder for MySQLcompatibility                                                       |
| `Collation`                | Takes the default value as per the character set and collation engine variables. By default it is`utf8_general_ci`. |
| `Checksum`                 | Default is null, used as a placeholder for MySQL compatibility.                                                     |
| `Create_options`           | Default is null, used as a placeholder for MySQL compatibility.                                                     |
| `Comment`                  | Comments                                                                                                            |
| `BuffMgr Memory Use`       | Buffer manager memory in use (in bytes)                                                                             |
| `Average GC Duration (ms)` | Average duration of garbage collection (in milliseconds)                                                            |

## Example

```

show table status \G

```

```output
*** 1. row ***
                    Name: x
                  Engine: MemSQL
                 Version: 10
              Row_format: Uncompressed
                    Rows: 130
          Avg_row_length: NULL
             Data_length: NULL
         Max_data_length: NULL
            Index_length: NULL
               Data_free: NULL
          Auto_increment: NULL
             Create_time: 2014-03-05 16:10:36
             Update_time: NULL
              Check_time: NULL
               Collation: utf8_general_ci
                Checksum: NULL
          Create_options: Not Available
                 Comment: Not Available
      BuffMgr Memory Use: 141472
Average GC Duration (ms): 0
1 row in set (0.00 sec)

```

***

Modified at: February 23, 2024

Source: [/db/v9.1/reference/sql-reference/show-commands/show-table-status/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-table-status/)

(An index of the documentation is available at /llms.txt)