CODEWITHSUNDEEP
sql
Alex Gordon
Alex Gordon

Reputation: 60751

free sql code editor?

i am breaking my eyes trying to write sql code in ms access. is there a free editor out there?

Upvotes: 8

Views: 10370

Answers (6)

transistor1
transistor1

Reputation: 2925

I wrote Access SQL Editor, an Add-In for Microsoft Access, because I had the same problem. There is a free 14-day trial here. Purchasing a license is very cheap, but if you can't afford it, you can contact me.

Once it's installed, you can access it through your Add-Ins menu (In Access 2010 it's Database Tools->Add Ins).

Upvotes: 1

Thalaivar
Thalaivar

Reputation: 23632

Microsoft® SQL Server® 2008 Management Studio Express

http://www.microsoft.com/downloads/details.aspx?FamilyID=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en

MS SQL Code Factory

http://www.sqlmaestro.com/products/mssql/codefactory/

DatabaseSpy SQL Editor

http://www.altova.com/databasespy/sql-editor.html

SQuirrel SQL Client

http://squirrel-sql.sourceforge.net/index.php?page=screenshots

Upvotes: 4

Adam Caviness
Adam Caviness

Reputation: 3484

I didn't see Notepad++ mentioned and of course you get the syntax highlighting but not any intellisense.

Upvotes: 1

Knox
Knox

Reputation: 2919

I haven't tried it yet, but I believe they improved the editor in Access 2010 . Here's a post from the Access Blog that discuss IntelliSense.

Upvotes: 1

Bill the Lizard
Bill the Lizard

Reputation: 405785

I normally use SQuirrel SQL Client to connect to just about any database I need to work with. You can use it with any database you can find a JDBC driver for.

Upvotes: 1

SLaks
SLaks

Reputation: 887469

SQL Server Management Studio Express

You should be able to use it as a SQL editor without SQL Server.

Upvotes: 2

Related Questions