![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » Search Forums » Search Results » View Thread |
Messages 1 to 6 of 6 total |
![]() |
Tue, Jul 12 2011 9:41 AM | Permanent Link |
Max Bernaert | 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. |
Tue, Jul 12 2011 10:08 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Max Nope. Roy Lambert |
Wed, Jul 13 2011 1:57 AM | Permanent Link |
Adam Brett Orixa Systems | 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 |
Wed, Jul 13 2011 11:51 AM | Permanent Link |
Max Bernaert | Adam Thank you. I put this in a unit and try to retrieve the information about the constraints. Thanks. Max. |
Wed, Jul 13 2011 12:00 PM | Permanent Link |
Max Bernaert | Ok, all elements are in the documentation sorry. Max. |
Wed, Jul 13 2011 12:07 PM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
This web page was last updated on Saturday, June 22, 2024 at 05:51 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |