JamesBranam's Blog
Thursday Oct 16, 2008
NetBeans 6.5: Creating Database Views
Hi all,
In NetBeans IDE, the Database Explorer enables you to create SQL views that are part of the database itself and are available to application programs and other clients of the database.
To create views:
- In the Services window, expand the node for a connected database.
- Right-click Views and choose Create View.
- In the Create View dialog box, type the name of the view in the View Name text field.
- In the text area, enter the SQL (SELECT) statement that will define the new view and click OK. The IDE adds a node for the new view under the Views node for the database.
Once the view is saved, you can see the data it contains by right-clicking the view in the Services window and choosing View Data.
See you tomorrow.
--James
Posted at 09:00AM Oct 16, 2008 by branajam in NetBeans | Comments[1]
James - Cool, however it would really useful to be able to create cross schema views in netbeans where the schema you are logged in as has grants to see other schemas. Currently you dont get to see these.
Posted by Neil Hathaway on October 16, 2008 at 11:11 AM CEST #