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