stucture of SQL table

[Otto]

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

[rhlawek]

In SQL it is referred to as DDL.

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

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

Robb

[nageswaragunupudi]

If you are using FWMariaDB

Code: Select all  Expand view  RUN

aStruct := oRs:aStructure
 

If you are using any ADO connection

Code: Select all  Expand view  RUN

   aStruct        := FWAdoStruct( oRs )