It is possible to print the sql of a table but can we print the table structure in ElevateDB as in previous versions in the database system utility?

Thanks

Max Bernaert.

Max


Nope.

Roy Lambert

But note Max that you can use SQL to extract information about the tables and tablecolumns of EDB from the information & configuration database and then use a third party report generator (i.e. FastReport etc.) to create a useful report of this structure.

i.e.

SELECT

 T.Name as TableName,
 TC.Name as ColumnName,
 TC.Type + ' ' + IF(TC.Collation IS NULL THEN '' ELSE TC.Collation)
 +IF("Length" is NULL THEN '' ELSE ' (Length: ' + CAST("Length" as CHAR(3))+')') as Details

FROM Information.Tables T
LEFT JOIN Information.TableColumns TC ON TC.TableName=T.Name

ORDER BY T.Name, TC.Name

Adam

Thank you. I put this in a unit and try to retrieve the information about the constraints.

Thanks.

Max.

Ok, all elements are in the documentation sorry.

Max.

Adam


This sort of thing is why I'd like to see Tim develop a plugin architecture for EDBManager - I'd be happy to start writing some utilities for it.

Roy Lambert