Schema Nodes

This section covers the following topics:

How the Schema Nodes Work

A Schema node is a child of the Schemas Node. Each node represents a database schema that you selected in the Filters Tab on the Connection Dialog. Schema nodes appear if you expand the Schemas node.

If you expand a Schema node, such as SYSTEM, the database schema object types nodes such as Tables or Views, appear as child nodes under the SYSTEM schema node.

To perform actions on a Schema node: right-click this node and from the menu choose the appropriate command. To view the node's properties, select the node and/or click Properties in the node's menu.

Menu Options

Menu Option	Description
Edit	Opens the designer so that you can edit the node.
Query Window	Opens the query window.
Generate Create Script	Writes the schema definition to a `.sql` file.
Generate Create Script to Project	Generates the schema definition to a .`sql` file and adds the `.sql` file to an open Oracle Database Project. If multiple objects in Server Explorer are selected, a master SQL script is created in the Oracle Database Project Scripts folder. This master script contains calls to individual child SQL scripts (one for each schema object) generated into the various schema object folders and this master script is ordered with dependencies taken into consideration. If there are multiple open Oracle Database projects, Visual Studio prompts you to select the project to add the script to. This operation can also be performed by dragging and dropping the Server Explorer node(s) directly onto a database project folder. See Managing Oracle Script Files for more information. Note: Oracle Database Project Version 2 projects are not supported. To add scripts to this project type, use Import Schema or Add Existing Item menu items on an Oracle Database Project Version 2 project folder, or use the Schema Compare tool.
Grant Debugging Privileges	Opens the Grant Debugging Privileges Dialog which grants to the user privileges neccessary for PL/SQL debugging on this computer. This menu option is only visible to users with `SYSDBA` privileges.
Privileges	Opens the privileges dialog.
Delete	Deletes the schema selected. Disabled for the current (connected) schema.
Refresh	Refreshes schema properties fetched from database.
Properties	Displays the properties window.