Wednesday, September 05, 2007

Tip: How to See NetBeans SQL

The NetBeans Database Explorer allows you to create tables, views, indexes and so on. There may be times when you want to see what SQL it is using to accomplish these operations, or perhaps you want to save the SQL into a script for future use.

It's pretty easy to do this, but you have to know what you do. You can Enable Debug fom the top-level folder of the Database Explorer (the one called "Databases")


Once you have enabled debug mode, you can perform DDL operations with NetBeans, and you will see the resulting SQL in an output window titled "Database Explorer"



Pretty nifty!

No comments: