How can I describe all tables in the database through one statement?

Question

Is there any statement that can describe all tables in a database?

Something like this:

describe * from myDB; 

Answer 1

There is no statement that describe all tables at once. But you may want to do something like this :

SELECT * FROM information_schema.columns WHERE table_schema = 'db_name'; 

Answer 2

because the other suggestions made very much mess on the screen or just did not do the trick here is a hack for a small db:

describe table_a; describe table_b; describe table_c;  

and so on