adam bien's blog

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.