Creating Views
See Also
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 Runtime window, expand the node for a connected database.
- Right-click Views and choose Add View.
- In the Add View dialog box, type the name of the view in the View Name text field. The IDE stores the name in a database.
- Enter the SQL (SELECT) statement into the text area 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 execute the SQL statement by right-clicking the view in the Runtime window and choosing View Data.
- See Also
- Creating Tables
Legal Notices