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.

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.