Tables Node

About Tables Node

A table is the basic unit of data storage in an Oracle database. Tables store data in rows and columns. Tables with Invalid Status are not displayed.

Oracle Database supports the following types of tables:

Relational
Object
XML

How the Tables Node Works

The Tables node contains the Relational Tables Node, Object Tables Node, and XML Tables Node category nodes. Each of these category nodes can contain one or more child Table Nodes that represent relational tables, object relational tables, or XML tables respectively.

To perform actions on the Tables 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.

If this collection node is filtered, the icon changes to include a funnel symbol. For more information about filtering, see Filtering Collection Nodes.

Menu Options

Menu Option	Description
New Relational Table	Creates a new table with relational and XMLType columns in the Table Designer.
New Object Table	Creates a new Object table in the Table Designer.
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.