Views
The Views tab of the SQL Metadata Tool allows you to create and modify views for your schema.
- Current schema
- The schema in which to create the view. The schema is selected in the Schemas tab.
- View name
- The name of the view. Select an existing view from the drop-down list, or enter a new view name and click New.
- SQL query for the view
- Enter your SQL query here.
- Check query
- Click to check your SQL query for errors.
- Save view
- This button appears when you have made changes to your view. Click to save your changes.
- Abandon changes
- This button appears when you have made changes to your view. Click to abandon your changes.
- Drop this view
- Click to delete the selected view. You must have
drop_schemaordrop_self_schema(if it is a personal schema) privileges.