How do I list all tables in Artisan Tinker?

@trendsideas

try with

$tables = \DB::select('show tables');

@tomo_pongrac Thanks but it returns this error:

Illuminate\Database\QueryException with message 'SQLSTATE[HY000]: General error: 1 near "show": syntax error (SQL: show tables)'

@trendsideas try this, I'm not sure but I think that might be it for sqlite:

DB::select('.tables');

@GwynBleidd Thanks but it returns a similar error,

Illuminate\Database\QueryException with message 'SQLSTATE[HY000]: General error: 1 near ".": syntax error (SQL: .tables)'

@trendsideas Uh, had to familiarize myself with sqlite a little for this :-)

Apparently, sqlite stores table names and schema in a special table called SQLITE_MASTER, so:

DB::select('select * from sqlite_master where type="table"')

and you'll get results like this:

     {#724
       +"type": "table",
       +"name": "migrations",
       +"tbl_name": "migrations",
       +"rootpage": "2",
       +"sql": "CREATE TABLE "migrations" ("migration" varchar not null, "batch" integer not null)",
     },

Update: or rather like this if you want it clearer

DB::select("SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;")

Source: https://www.sqlite.org/faq.html#q7

@GwynBleidd WooHoo Thank you so much. You're a life saver :)