XML Tables Node

This section covers the following topics:

About XML Tables Node

This category node is a child node of Tables Node. It contains a set of child TTable Nodes which represent all XML tables visible to the user.

How the XML Tables node Works

To perform actions on this node, right-click the 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

New XML Table

Creates a new XML table in the Table Designer.

Import Table

Launches the Import Table Wizard. See Import Table Wizard.

Query Window

Opens the Query Window so that you can execute SQL and PL/SQL queries from Visual Studio.

Filters

Opens the Filters Tab to control which child nodes appear under the collection.

Privileges

Opens the Grant/Revoke Privileges dialog box.

Generate Create Script

Writes all table definitions to a .sql file.

Generate Create Script to Project

Generates the table definitions 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.

Refresh

Updates the Tables node tree, including its associated table nodes.

Properties

Displays the Properties window.

See Also

Table Nodes | Table Column Node | Table Designer | Oracle Data Window