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

please format code with </> button * homework policy * asking questions

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.

Hi,

The SHOW TABLE STATUS command exists in MySQL : MySQL :: MySQL 8.0 Reference Manual :: 13.7.7.38 SHOW TABLE STATUS Statement

but doesn’t look like it’s supported in SQlite (you can try it here : SQLite Editor)

You can use the .tables command to show all the tables : SQLite Show Tables: Listing All Tables in a Database

3 Likes

@josephh

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

1 Like