Monday, May 13, 2013

SQL Formatting Tools


Instant SQL Formatter – This is ready to use and free. Just set output to: List DB Object. Outputs the data as follows:

output the details like this:

Tables:

Employee_Table

Fields:

Employee_Table.Address

Employee_Table.Name

Employee_Table.Phone_Number

SQL Parser - http://www.sqlparser.com/fetch-table-column-name-example-extact-all-table-field-name.php - We have not tried it as some coding or at least compiling of their sample code is needed. Seems to support the generic HTML, will need to test if there are complex BOSS queries.

Code generator - http://www.newrad.com/software/sqlvbcodegenerator/ - Not free ($199). This is more for generating code / web pages wrapping SQL. 

No comments:

Post a Comment