FiveTech Software tech support forums

Posted: **Sun Jul 13, 2008 4:43 am**

Hi Friends:

Is there a way to know the structure of a MySql table ?

Regards and thanks in davance

Posted: **Sun Jul 13, 2008 4:50 am**

Armando wrote:Is there a way to know the structure of a MySql table ?

With SQLRDD its DbStruct()

Patrick

Posted: **Sun Jul 13, 2008 12:08 pm**

Try using ADOX:

FUNCTION MAIN()

    LOCAL oCat

    LOCAL i, j

    oCat = CREATEOBJECT( "ADOX.Catalog" )

    oCat:ActiveConnection = "your connection string"

    FOR i = 0 TO oCat:Tables:Count() - 1
        ? oCat:Tables( i ):Name
        ?

        FOR j = 0 TO oCat:Tables( i ):Columns:Count() - 1
            ? SPACE( 4 ) + oCat:Tables( i ):Columns( j ):Name
        NEXT

        ?
    NEXT

    RETURN NIL

EMG

Posted: **Sun Jul 13, 2008 5:12 pm**

Friends:

Patrick, thanks for your answer but I have not SQLRDD.

Enrico: thanks for your reply, problem solved.

Best regards for all

FiveTech Software tech support forums

Structure of a Table ?

Structure of a Table ?

Re: Structure of a Table ?

Re: Structure of a Table ?