Sequence Nodes

This section covers the following topics:

How Sequence Nodes Work

The Sequence node is a child of the Sequences node.

Starting with Visual Studio 2005, you can edit the name of the sequence in place by selecting the name and then clicking it to open an edit box or by choosing the Rename menu option to open the edit box.

Note: This feature only works in Visual Studio 2005.

To perform actions on the Sequences node: right-click the 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
Edit	Edits the sequence using the Sequence Designer. Alternatively, double-clicking a sequence node opens the Sequence Designer for that sequence.
Query Window	Opens the Query Window so that you can execute SQL and PL/SQL queries from Visual Studio.
Generate Create Script	Writes the sequence definition to a `.sql` file.
Generate Create Script to Project	Generates the sequence definition 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.
Dependencies and References	Opens the Dependencies and References Viewer for viewing the dependencies that this object has on other database schema objects.
Privileges	Opens the Grant/Revoke Privileges dialog box.
Delete	Drops the sequence.
Rename	Allows you to edit the Sequence name in place in Server Explorer. Alternatively, you can select the Sequence name and then click one more time to open an edit box.
Refresh	Updates the Sequence node tree, including its associated sequence nodes. If the database object associated with the node was deleted from the database, you will be asked if the node needs to be deleted from the Server Explorer.
Properties	Displays the Properties window.