Re^2: sqlite show tables

Replies are listed 'Best First'.
Re^3: sqlite show tables by dsheroh (Monsignor) on Jul 20, 2021 at 07:25 UTC
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)	[reply] [d/l] [select]
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]
Re^5: sqlite show tables by hippo (Archbishop) on Jul 20, 2021 at 08:35 UTC
You have misread the documentation. Only calling `tables` with no arguments is deprecated. 🦛	[reply] [d/l]