> For the complete documentation index, see [llms.txt](https://docs.tableplus.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tableplus.com/gui-tools/database-objects/procedure.md).

# Procedure

## **Create** Procedure

To create a new procedure:

* Right click on the left sidebar and choose **`New`** > **`Function/Procedure`**. Or you can also click on the dropdown menu at the bottom of the left sidebar and choose **`New Function/Procedure`**
* Write the SQL command.
* After you finish, press **`⌘ + S`** to commit changes to the server.

![](/files/-Lrt1KXqpHzYVzS7XI4k)

## **Edit** Procedure

To edit an existing procedure:

* Click on the function name on the left sidebar to view the procedure
* Edit the SQL code
* Press **`⌘ + S`** to commit changes to the server.

## **Delete** Procedure

To delete a procedure, right click on the procedure name on the left sidebar and choose **`Delete`**, or select the procedure and press Delete key.