FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour stucture of SQL table
Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
stucture of SQL table
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

Posts: 195
Joined: Sun Jul 22, 2012 07:01 PM
Re: stucture of SQL table
Posted: Wed May 01, 2019 01: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

Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: stucture of SQL table
Posted: Wed May 01, 2019 01:37 PM
If you are using FWMariaDB
Code (fw): Select all Collapse
aStruct := oRs:aStructure


If you are using any ADO connection
Code (fw): Select all Collapse
   aStruct        := FWAdoStruct( oRs )
Regards



G. N. Rao.

Hyderabad, India

Continue the discussion