Running a Trigger

Run a trigger to obtain SQL results from the database.

1. In the Databases folder in Enterprise Explorer, under the database connection profile, expand the navigation tree for the appropriate database and schema owner.

   Database	Steps
   From an ASE connection profile	Expand the Databases folder. Expand the tree for a database and then the tree for the appropriate schema owner.
   From a SQL Anywhere or Sybase IQ connection profile	Expand the tree for a database. Expand the Schemas folder and then the tree for the appropriate schema owner.

2. Expand the Tables folder, the table where the trigger is located, and then the Triggers folder.
3. Right-click the trigger and select Run.
4. Make sure the Trigger field in the Type frame is selected.
5. To modify the trigger SQL, click the SQL... button, and select Insert, Update, or Delete.
6. Construct a query with Visual SQL, and click OK.
7. Click Apply to apply the value changes to the launch configuration.
8. Click Run to run the trigger.

   View results in SQL Results view.

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com