View Column Node

This section covers the following topics:

How the View Column Node Works

An Object type view has no columns. When you expand an Object type view node, the object (user-defined type) used by the view appears under the view node.An XML view always has only one column SYS_NC_ROWINFO$, which is the only view column node that appears under the XML view node.When you expand an user-defined type column node, the user-defined type used by the column node appears under the column node.

To perform actions on the View Column node: right-click this node and from the menu choose the appropriate command. To view the node's properties, select Properties from the menu.

Drag and Drop Support

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

Please see the following Microsoft documentation:

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

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

Menu Options

Menu Option Description

Design

Edits the column using the View Designer.

Copy

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

Refresh

Updates the View Column node.

Properties

Displays the Properties window.