MariaDB Database / Table Structure

Hi Everyone.

I am wondering if there are database queries that would

a: produce the result of all the tables with a database *
b: produce the result of all the columns with the specified database table *

* I don't want any other details than these names.

I am trying to build a WHILE loop that in pseudo code will look roughly like

- query to get a list of all the tables within a database
- start of a foreach loop (going one table at a time

    - query to get all the column names within the table
    - start of a foreach loop to display column names
    - display column name
    - end of foreach loop

-end of foreach loop

Ron