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

[yoge]

Try this query -
show table status from YourDatabaseName;

ninjajs wrote:

>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.
>
>  
>