Hello.
See:
http://dev.mysql.com/doc/mysql/en/SHOW_CREATE_TABLE.html
ninjajs <xyzzyjs@stripped> 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.
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
