Netbeans 6.5: Nice "Hidden" Feature In The SQL Explorer

  1. Open the tab "Services" (Ctrl+5)
  2. Connect to a database
  3. Select a table and invoke "View Data" from the context menu
  4. The data will be displayed in a table.
  5. Right click on row in the table. A context menu with "Insert Record", "Delete Recort" ...Show SQL Script etc. should open. These are actually useful functions which create Insert, Update, Delete and even create statements for you. The create statements are not always syntactically correct (they sometimes end with a comma), but useful anyway.
What I miss is the no more existing visual explorer. It disappeared in NB 6.1. It was possible with "Design Query" wizard to visualize table and connections between them. I never used it to actually design a query, but just to visualize the relations between tables.

Comments:

Indeed, the editing features in the table view are rather helpful, but more than that I am just happy to see the ability to store SQL Command sheets appear in recent NetBeans builds. This is something that has been missing for way too long... ;)
K.

Posted by Kristian on December 03, 2008 at 11:12 AM CET #

prety informative screencast on topic:
http://netbeans.tv/screencasts/NetBeans-6.5%3A-Database-Support-Improvements-403/

the screencast demonstrates at around 4:45 the SQL History (also a well hidden gimmic ;-))

Posted by mbien on December 03, 2008 at 11:46 AM CET #

I still miss a visual designer to design database tables. Afterwards it should be possible to make this tool create your database entities.
How do u solve this requirement?

Posted by Daniel on December 04, 2008 at 05:33 PM CET #

Hi,

This would make a fantastic contribution to the NB Community Docs wiki. Could you please submit it?

Thanks a lot,

--James Branam

Posted by James Branam on December 09, 2008 at 12:25 PM CET #

Post a Comment:
  • HTML Syntax: NOT allowed
...the last 150 posts
...the last 10 comments
License