# **SHOW ACCOUNTS**

## **Function Description**

List meta-information and statistics for tenant users created under your account.

## **Function Syntax**

```sql
SHOW ACCOUNTS;
```

### Tenant user information details

| Column Name | Information | Type | Data Source |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| ACCOUNT_NAME | Tenant Name | varchar | mo_account |
| ADMIN_NAME | Default super administrator name when creating | varchar | in the mo_user table under each tenant |
| CREATED | Creation time | timestamp | mo_account |
| STATUS | Current status, OPEN or SUSPENDED | varchar | mo_account |
| SUSPENDED_TIME | Deactivation time | timestamp | mo_account |
| DB_COUNT | Number of databases | bigint unsigned | mo_tables |
| TABLE_COUNT | Number of tables | bigint unsigned | mo_tables |
| ROW_COUNT | Total row count | bigint unsigned | sum(mo_table_rows()) |
| SIZE | Total space used (MB) | decimal(29,3) | sum(mo_table_size(mt.reldatabase,mt.relname) |
| COMMENT | COMMENT information at creation | varchar | mo_account |

## **Example**

```text
mysql> show accounts;
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| account_name | admin_name | created | status | suspended_time | db_count | table_count | size | comment |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| d95042d3_d421_4d9a_8d09_0bd56858xxxx | admin | 2024-02-04 02:08:54 | open | NULL | 9 | 64 | 285.436627 | |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.22 sec)
```