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
  • Reuse a query from History
  • Delete query
  • Save to Favorite
  • Find the query location

Was this helpful?

  1. Query Editor

Query History

PreviousQuery Favorite & Keyword BindingNextStreaming Results & Async Loading

Last updated 5 years ago

Was this helpful?

All queries submitted via the Query Editor will be logged in the History tab on the left sidebar.

Reuse a query from History

To use a query from the history:

  • Double click on the query to insert in into the current Query Editor.

  • Right click on the query in the History and choose:

    • Copy to copy the query to the clipboard

    • Run to execute the query in a new tab

    • Open in anew tab to open Query Editor in a new tab and insert the query into it.

    • Insert to SQL Editor to insert the query into the current Query Editor.

Delete query

To delete a query from History, right click on the query and choose Delete

To clear all query history, right click on a query and choose Clear all history

Save to Favorite

To save a query from History to Favorite:

  • Right click on the query and choose Add to favorite

  • Name the query and assign the bending keyword

  • Press ⌘ + S to save, then close the window.

Find the query location

To see the location of the SQL file that contains query, right click on the query and choose Show in Finder