I'd like to know SQL query for table description.

[ninjajs]

Hi. ALL

i have a database in MySQL.

A middleware request to MySQL DB server.

and then, result is table description.

ex) 
dbms_type,table_name,column_name,data_type,data_size,constraint_type

What SQL query can I get this information ?

thank you.