Comparing Table Structures

PHP
1

is there a function that sends a tables structure to an array so I can make comparisons?

2

What do you mean by ‘table structure’?

3

the display I get from phpmyadmin when I click the structure tab. Is there a function to get that into an array?

4

you can run queries against the INFORMATION_SCHEMA tables

you’ll probably want to query the INFORMATION_SCHEMA.COLUMNS table, giving a table name for the search criterion in the WHERE clause

5

Thanks C. Ankerstjerne and r937. the INFORMATION_SCHEMA is the ticket I needed