Retrieve MYSQL Table Structure

I am using Delphi 6,MySQL ODBC 3.51 Driver,TADOQuery and MySQL as my Database.
How can I retrieve the sturcture of my tables in for ff format.

[Field Name][Type]

ITE_CODE Char(14)
ITE_DESC Char(40)

I have an existing table called MITEMS
I already used the commands like
DESC MITEMS
SHOW COLUMNS FROM MITEMS

But it always raise an exception
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories