Tags: Eclipse

Today I came to know one cool plugin of Eclipse. Its SQL Explorer, some of you may aware of this awesome plugin. This article for those who not heard about this plugin ever.

Features: 

• Connect remote databases.
• Able to show Tables, Function, View, Stored Procedure, etc...
• Quick preview of table contains (Table Structure, Foreign keys, Indexes, etc...)
• Query execution history.

• Can't execute Stored Procedure, Function, etc... from SQL Explorer

---

Prerequisite:

• sqlexplorer_plugin-3.6.1_SR6 (Download Or http://sourceforge.net/projects/eclipsesql/files/SQL%20Explorer%20Plugin/)
• sqljdbc-1.2.0.jar (Download Or http://www.java2s.com/Code/Jar/s/Downloadsqljdbc120jar.htm)

Note: Download from original site in-case you face some issue for your eclipse environment.

Step 1: Download and extract sqlexplorer_plugin-3.6.1_SR6.zip file. Merge it with eclipse `features` and `plugins` folder.

Step 2: Restart eclipse.

Step 3: Go to Window > Preferences > SQL Explorer and follow step as below image and click Edit.


Step 4: Click on Extra Class Path > Add JARs and select `sqljdbc-1.2.0.jar` from location you downloaded at starting of this article. Then click on List Drivers. Click OK on both popup window.


Step 5: Now you are good to go. All You need to open perspective window in eclipse. Go to Window > Open Perspective > Other > SQL Explorer.

Step 6: You'll have SQL Explorer window open in your eclipse. In left pan you'll have connection tab. Right click in that tab area create new connection.

Step 7: Provide your connection details in popup window and click ok.


That's it. We are done with SQL Explorer setup. Enjoy your new SQL editor. Open below image in new tab to check out SQL Explorer in Eclipse.

Tags: Eclipse