Exporting Database Structure?

[malfist]

I just took over a web app from a programer that just left work. It is a very database heavy application, so in the docs it has a detailed listing of the database structure and the sql to rebuild it. The problem is, the structure described is his first prototype, not at all what is now in use. I know phpMyAdmin has a way to export the stucture of a database, but that is not avaliable. My boss has access to MySQL Query Browser but doesn't have that option and she's out all week. The only access I have to the database is through PHP (i.e. no commandline, not mysqldump). Is there a way I can export the database structure so I can see what I'm working on?

 

Thanks,

Malfist 

[malfist]

 Also, I can't use exec(), it uses the IIS default account with no permisions (as it should) and I can't change that.

[brazzy]

MySQL :: MySQL 8.0 Reference Manual :: 15.7.7.10 SHOW CREATE TABLE Statement

[malfist]

Thanks!