1. Home
  2. Docs
  3. Query Builder
  4. Stored procedures

Stored procedures

Write / on an empty line to enter a stored procedure, stored function or database trigger.


drop procedure if exists DEPT

create procedure DEPT()
  select * from dept;

call DEPT()

Presuming table dept is available in the selected database, the code above will show three tabs:

  1. Result of the drop procedure command
  2. Result of the create procedure command
  3. Result of the procedure call
Was this article helpful to you? Yes No

Leave a Reply

Your email address will not be published.