FiveTech Software tech support forums

Posted: **Wed May 01, 2019 12:07 pm**

Dear Mr. Rao,
how can we get the structure of a SQL table.
Can you please tell me where I can find documentation for maria lib.
Thank you in advance

Otto

Posted: **Wed May 01, 2019 1:14 pm**

In SQL it is referred to as DDL.

https://stackoverflow.com/questions/659 ... e-in-mysql

show create table <database name>.<table name>;

Robb

Posted: **Wed May 01, 2019 1:37 pm**

If you are using FWMariaDB

Code: Select all

aStruct := oRs:aStructure

If you are using any ADO connection

Code: Select all

   aStruct        := FWAdoStruct( oRs )

FiveTech Software tech support forums

stucture of SQL table

stucture of SQL table

Re: stucture of SQL table

Re: stucture of SQL table