ThePsion5 Posted January 30, 2006 Share Posted January 30, 2006 Hi,I'm writing many statements in SQL in a notepad file, but after awhile it can get hard to distinguish SQL statements from table names, despite using caps and formatting my statements. Are there any utilities out there that will do something along the lines of color-coding SQL syntax, like Dreamweaver does HTML?Thanks in advance. Link to comment Share on other sites More sharing options...
Skemcin Posted January 31, 2006 Share Posted January 31, 2006 I understand what you mean. I use a tool called DB Manager Professional. I'm on version 3.0.2 (which is completely free). When you write statements in its query writing interface, it color codes things quite nicely. SQL commands in blue, fields in red and tables in black - for instance.You can download it here:http://www.dbtools.com.br/EN/downloads/The enterprise version cost money - but the freeware only supports one DB type - ie. MYSQL or PostgreSQL. SO I use the MYSQL freeware version. Link to comment Share on other sites More sharing options...
aspnetguy Posted January 31, 2006 Share Posted January 31, 2006 If you are using SQL Server you could write and test your queries in the Query Analyser...it color codes things nicely too. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now