Table Triggers Node
This section covers the following topics:
About Table Triggers Node
This category node is a child node of Triggers Node. It contains a set of child Trigger Nodes which represent all table triggers visible to the user.
How the Table Triggers Node Works
To perform actions on this 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 |
|---|---|
|
Add Trigger |
Creates a new trigger with the Trigger Designer. This command is not supported for object tables or object views. |
|
Query Window |
Opens the Query Window so that you can execute SQL and PL/SQL queries from Visual Studio. |
|
Generate Create Script |
Writes the trigger definitions to a If the object associated with the triggers node is deleted from the database backend, this menu option does the following: Displays a message indicating that this object no longer exists in Oracle Database, and the script will not be generated. |
|
Generate Create Script to Project |
Generates the trigger definitions to a . 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. |
|
Filters |
Opens the Filters Tab to control which child nodes appear under the collection. |
|
Refresh |
Updates the Triggers node tree, including its associated trigger nodes. |
|
Properties |
Displays the Properties window. |
See Also