in reply to Re^2: sqlite show tables
in thread sqlite show tables

I don't actually know. I've never tried using .schema (or show tables with mysql) in DBI code, only in the interactive clients. When I've wanted to get a database's list of tables from DBI code, I've done it with my @tables = $dbh->tables(undef, undef, undef, 'TABLE'); (Documentation)

Replies are listed 'Best First'.
Re^4: sqlite show tables
by igoryonya (Pilgrim) on Jul 20, 2021 at 07:40 UTC
    Hm, looks like, they've marked it (->tables) as deprecated.
[reply]

      You have misread the documentation. Only calling tables with no arguments is deprecated.

      🦛

[reply]
[d/l]

In Section Seekers of Perl Wisdom