A site devoted mostly to everything related to Information Technology under the sun - among other things.

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:

About Me

My photo
I had been a senior software developer working for HP and GM. I am interested in intelligent and scientific computing. I am passionate about computers as enablers for human imagination. The contents of this site are not in any way, shape, or form endorsed, approved, or otherwise authorized by HP, its subsidiaries, or its officers and shareholders.

Blog Archive