JoaoHamerski's avatar

How list all tables of database using sqlite in Laravel?

I know that using MySQL or Postgres i can do DB::select('SHOW TABLES') but using a sqlite database it isn't working. I got this error:

SQLSTATE[HY000]: General error: 1 near "SHOW": syntax error (SQL: SHOW TABLES)

I tried using sqlite syntax with DB::select('.tables') but got a syntax error too.

0 likes
1 reply

Please or to participate in this conversation.