Procedure

Stored procedures are listed together with functions in the Functions section of the left sidebar. They are available for databases that support them, such as PostgreSQL, MySQL, MariaDB, and SQL Server; SQLite has no procedures. Changes are kept locally until you press ⌘ + S¹ to commit them to the server.

Create procedure

1. Right-click the left sidebar and choose New > Function/Procedure, or click the arrow next to the + button at the bottom of the left sidebar and choose New Function/Procedure.
2. Write the CREATE PROCEDURE statement in the editor.
3. Press ⌘ + S to create the procedure.

Edit procedure

1. Click the procedure in the left sidebar to open its definition.
2. Edit the SQL code.
3. Press ⌘ + S to commit the change.

Delete procedure

1. Right-click the procedure in the left sidebar and choose Delete..., or select it and press Delete.
2. Press ⌘ + S to commit the change.