MariaDB Database / Table Structure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux