Table Column Node

This section covers the following topics:

How the Table Column Nodes Work

A Table Column node represents a single column in the enclosing relational table.

An Object type table has no columns. When you expand an Object type table node, the object (user-defined type) used by the table is displayed under the table node.

An XML table always has only one column, SYS_NC_ROWINFO$, which is the only table column node that appears under the XML table node.

When you expand an user-defined type column node, the user-defined type appears under the column node.

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

Drag and Drop Support

You can automatically generate a query for a table by dragging the table column node onto the Oracle Query Window. Dragging a table column node onto the Oracle Query Window generates a query that selects that column from the corresponding table.

Also, you can automatically generate a query for a table column by dragging the table column node onto the Microsoft Query Designer. This generate a query that selects the column from the corresponding table.

This node can be dragged and dropped into DataSet Designers and XML Schema Designers.

Please see the following Microsoft documentation:

Menu Options

Menu Option Description

Design Table

Edits the table column using the Table Designer.

Copy

Copies the selected column to the clipboard for pasting to Visual Studio designers. This provides the same functionality as dragging and dropping the column to the Visual Studio designers.

Refresh

Updates the Table Column node tree, including all its associated table nodes.

Properties

Displays the Properties window.