TablePlus Documentation
  • Overview
  • Getting Started
  • GUI Tools
    • The Interface
      • Quick Look
      • Menu
      • Toolbar
      • Left sidebar
      • Right sidebar
      • Console Log
      • Query Editor
      • Multi Tabs / Workspaces / Windows
    • Open Anything
    • Code Review & Safemode
      • Code Preview
      • Commit changes
      • Discard changes
      • Safe mode
    • Connections & Command Line (CLI)
    • Database
    • Working with Table
      • Table Basics
      • Row
      • Column
      • Constraint
      • Index
      • Trigger
    • Filter
    • Database Objects
      • Function
      • Procedure
      • View
    • Import & Export
    • Backup & Restore
    • User Management
    • Metrics board
  • Query Editor
    • Editor Basics
    • Multiple Carets
    • Query Favorite & Keyword Binding
    • Query History
    • Streaming Results & Async Loading
    • Autocomplete
    • Split Panes
    • Split Results into Tabs
    • Working With Query Results
    • Format query (beautify/minify/uglify)
    • Query Parameters
    • Customize Query Editor
  • Preferences
    • General
      • Application
      • Table Data
      • SQL Editor
      • CSV File
      • Connections
    • Fonts & Colors
    • Crash & Security
    • Keymap
  • Utilities
    • Plugin
    • DBngin
    • Shortcut Keys
    • Licensing
    • Troubleshooting
Powered by GitBook
On this page
  • Create trigger
  • Edit trigger
  • Delete trigger

Was this helpful?

  1. GUI Tools
  2. Working with Table

Trigger

PreviousIndexNextFilter

Last updated 5 years ago

Was this helpful?

Create trigger

  • Open the table structure view (⌘ + ^ + ]).

  • Click on the Triggers button near the top right of the structure view.

  • Click on the + Trigger button or double click on the blank row.

  • Specify the trigger's attributes and write the trigger statement.

  • Press ⌘ + S to commit changes to the server.

Edit trigger

  • Open the table structure view (⌘ + ^ + ])

  • Click on the Triggers button near the top right to see all existing triggers.

  • Double click on trigger's attribute and edit inline.

  • Press ⌘ + S to commit changes to the server.

Delete trigger

  • Open the table structure view (⌘ + ^ + ]).

  • Click on the Triggers button near the top right to see all existing triggers.

  • Select the trigger and press Delete key, or right click and choose Delete.

  • Press ⌘ + S to commit changes to the server.