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:
-
DataSet Designer
http://msdn2.microsoft.com/en-us/library/314t4see(VS.80).aspx
-
XML Schema Designer
http://msdn2.microsoft.com/en-us/library/ms171943(vs.80).aspx
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. |
See Also
Tables Node | Table Nodes | Table Column Node | Table Designer | Oracle Data Window | XML Schema Designer