Most DBs provide introspection via SQL, for example MySQL/MariaBD's
SHOW command. I know in this particular cast, this represents maybe an additional and unnecessary call. But in the future it's good to know this is exposed via SQL and therefore available to you via DBI just like any other SQL.