# \[bezier.data.sql library\] SHOW TABLE STATUS / It doesn't work. / help me

**URL:** <https://discourse.processing.org/t/bezier-data-sql-library-show-table-status-it-doesnt-work-help-me/30179>\
**Category:** Libraries\
**Created:** [May 19, 2021, 10:22pm UTC](https://discourse.processing.org/t/bezier-data-sql-library-show-table-status-it-doesnt-work-help-me/30179 "2021-05-19T22:22:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![GWAK](https://avatars.discourse-cdn.com/v4/letter/g/13edae/32.png) [@GWAK](https://discourse.processing.org/u/GWAK)\
**Post date:** [May 19, 2021, 10:22pm UTC](https://discourse.processing.org/t/bezier-data-sql-library-show-table-status-it-doesnt-work-help-me/30179/1 "2021-05-19T22:22:10Z")

</div>

> please format code with \</\> button \* [homework policy](https://discourse.processing.org/faq/#homework) \* [asking questions](https://discourse.processing.org/t/2147)

```auto
import de.bezier.data.sql.*;

SQLite db;
String SHOW_TABLE_STATUS = "SHOW TABLE STATUS";
String SHOW_TABLE_STATUS2 = "SHOW TABLES";

void setup()
{
  size( 100, 100 );

  db = new SQLite( this, "test.db" ); // open database file
  db.connect();
  db.execute(SHOW_TABLE_STATUS ); 

}

```

Good morning. nice to meet you.

‘SHOW’ command does not work.

1. Is the’SHOW’ command originally not allowed?
2. How can I check the table name in the current .db?

help me.

---

<div class="post-metadata">

**Author:** ![josephh](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.processing.org/josephh/32/210_2.png) [@josephh](https://discourse.processing.org/u/josephh)\
**Post date:** [May 19, 2021, 10:34pm UTC](https://discourse.processing.org/t/bezier-data-sql-library-show-table-status-it-doesnt-work-help-me/30179/2 "2021-05-19T22:34:07Z")

</div>

Hi,

The `SHOW TABLE STATUS` command exists in MySQL : [MySQL :: MySQL 8.0 Reference Manual :: 13.7.7.38 SHOW TABLE STATUS Statement](https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html)

but doesn’t look like it’s supported in SQlite (you can try it here : [SQLite Editor](https://www.sqlitetutorial.net/tryit/))

> <https://stackoverflow.com/questions/59709946/sqlite3-operationalerror-near-show-syntax-error>

You can use the `.tables` command to show all the tables : [SQLite Show Tables: Listing All Tables in a Database](https://www.sqlitetutorial.net/sqlite-tutorial/sqlite-show-tables/)

---

<div class="post-metadata">

**Author:** ![GWAK](https://avatars.discourse-cdn.com/v4/letter/g/13edae/32.png) [@GWAK](https://discourse.processing.org/u/GWAK)\
**Post date:** [May 20, 2021, 12:11am UTC](https://discourse.processing.org/t/bezier-data-sql-library-show-table-status-it-doesnt-work-help-me/30179/3 "2021-05-20T00:11:18Z")

</div>

@josephh

This is the answer I want. Thank you very much.