Quick Start
Connect to MySQL
HTTP Tunnel
SSH Tunnel
Databases
Schema
Tables
Adding Fields and Choosing Data Types
Customising Fields
Primary Keys and Indexes
Filter Wizard
Foreign Keys
Foreign Keys Data Selection
Uniques and Checks
Rules and Triggers
Privileges
Import/Export
Function
View
Tablespace
Cast
Language
Aggregate
Conversion
Domain
Trigger Function
Operator
Operator Class
Sequence
Type
Queries
Visual Query Builder
Data
Manage Users
Backup
Data Transfer
Schedule
Server Monitor
Data Synchronization
Structure Synchronization
Console
Virtual Grouping
Maintaining your databases/tables
Preferences
General
Tabs
Tables
Queries
  Working with Rules and Triggers
 

Rules

Table rules are managed on the Rules tab of the Table Designer.

Create a rule

  1. Open the table in Design View
  2. Select the Rule tab
  3. To add a new rule, click Add Rule button from the toolbar
  4. In the Rule Name column enter the name of the Rule
  5. Edit rule properties on the appropriate tabs
  6. Click Save or Save As from the toolbar when you are ready to save the table

Delete an existing rule

  1. Open the table in Design View
  2. Select the Rule tab
  3. Select the rule you want to delete and click Delete Rule button from the toolbar
  4. Click Save or Save As from the toolbar when you are ready to save the table


Triggers

Table triggers are managed on the Triggers tab of the Table Designer.

Create a trigger

  1. Open the table in Design View
  2. Select the Trigger tab
  3. To add a new trigger , click Add Trigger button from the toolbar
  4. In the Trigger Name column enter the name of the Trigger
  5. Edit trigger properties on the appropriate tabs
  6. Click Save or Save As from the toolbar when you are ready to save the table

Delete an existing trigger

  1. Open the table in Design View
  2. Select the Trigger tab
  3. Select the trigger you want to delete and click Delete Trigger button from the toolbar
  4. Click Save or Save As from the toolbar when you are ready to save the table