Structure of a Table ?

[Armando]

Hi Friends:

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

Regards and thanks in davance

[Patrick Mast]

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

With SQLRDD its DbStruct()

Patrick

[Enrico Maria Giordano]

Try using ADOX:

Code: Select all

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

[Armando]

Friends:

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

Enrico: thanks for your reply, problem solved.

Best regards for all