how to get table structure as an SQL query in phpmyadmin

Question

I have many tables in my MySQL database & I want to know the table structure of all tables.

When I type desc tableName in SQL Column I see the table structure in tabular format. How can I get the table structure in SQL query format as we normally see?

---

Answer

I found answer in below link.

https://dba.stackexchange.com/questions/15537/how-to-display-database-structure-in-phpmyadmin

Answer 1

Do you mean:

desc TABLENAME\G;